soccer_champ

• Jun 18th, 2005

 

When a database user is created, a corresponding schema with the same name is created for that user.  
 
A schema is a named collection of objects that include Tables, Triggers, constraints, Indexes, Views, Sequences, clusters, procedures and packages that are associated with a particular user, etc..

Jacob

• Jul 9th, 2005

 

A schema is a collection of database objects. A schema is owned by a database user and has the same name as that user. Schema objects are logical structures created by users. Objects may define areas of the database to hold data, such as tables or indexes, or may consist just of a definition, such as a views or synonyms. 
 
There is no relationship between a tablespace and a schema. Objects in the same schema can use storage in different tablespaces, and a tablespace can contain data from different schemas. 
 
Schema objects can be created and manipulated using SQL. As an administrator, you can create and manipulate schema objects, just as you do with the logical and physical structures of your database using Oracle Enterprise Manager. The underlying SQL is generated for you by Oracle Enterprise Manager. 
 
 

Sriniv@s..

• Jun 5th, 2012

 

Schema is a set of objects own by particular user.
Tables,indexes,Triggers,constraints etc..are schema objects..