Difference between user and schema oracle?

Post date: 28-Sep-2010 08:59:18

* A schema is collection of database objects, including logical structures such as tables, views, sequences, stored procedures, synonyms, indexes, clusters, and database links.

* A user owns a schema.

* A user and a schema have the same name.

* The CREATE USER command creates a user. It also automatically creates a schema for that user.

* The CREATE SCHEMA command does not create a "schema" as it implies, it just allows you to create multiple tables and views and perform multiple grants in your own schema in a single transaction.

* For all intents and purposes you can consider a user to be a schema and a schema to be a user.

Technically, a schema is a collection of database objects owned by a specific user. Those objects include tables, indexes, views, stored procedures, etc. In Oracle, a schema requires a user to be created. But you can create a user that has no schema (i.e, no objects). So in Oracle, the user is the account and the schema is the objects.