Mohammed Abdul Afroze

• Sep 20th, 2007

 

Schema is a Collection of Database objects of a user.
Example: Tables, Views, Synonyms, Sequences, Clusters, Triggers, Procedures, Packages.

rach

• Jul 23rd, 2011

 

schema describes the structure of the database. database has so many fields like constraints, table etc, so called these fields separately we call it schema.

Mohammad Mujeeb

• Oct 25th, 2011

 

schema is a collect of object (table,view,cluster etc) that belongs to an user account.

ARUN BHUKKER

 Profile Answers by ARUN BHUKKER 

• Oct 19th, 2012

 

A schema is the set of objects (tables, views, indexes, etc) that belongs to an user account. It is often used as another way to refer to an Oracle account.
Most Oracle database installations traditionally came with a default schema called SCOTT.
Most recent examples supplied by Oracle Corporation reference the default HR or OE schemas.