soccer_champ
Answered On : 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..

1 User has rated as useful.
Login to rate this answer.
Jacob
Answered On : 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.
Login to rate this answer.
Sriniv@s..
Answered On : Jun 5th, 2012
Schema is a set of objects own by particular user.
Tables,indexes,Triggers,constraints etc..are schema objects..
Login to rate this answer.