oracle-databaseoracle11gschema

Difference between Schema and Owner of Table


Is the schema for a table and the owner for a table the same in oracle? If not what is the difference?


Solution

  • As Tom says:

    You should consider a schema to be the user account and collection of all objects therein as a schema for all intents and purposes.

    A table created by a user - and therefore owned by that user, as the owner in all_tables for example - forms part of that user's schema. So yes, the owner and schema are the same.

    Also see this earlier question, which references the same AskTom post, and also highlights this line from it:

    for all intents and purposes just consider user = schema = user = schema = the same thing