What is the difference between a user and a schema in Oracle?
Oracle – Difference between a user and a schema in Oracle
oracle
Related Topic
- Sql – Get list of all tables in Oracle
- Sql – How to limit the number of rows returned by an Oracle query after ordering
- Oracle – the difference between varchar and varchar2 in Oracle
- Oracle – the difference between precision and scale
- Oracle – How to generate an entity-relationship (ER) diagram using Oracle SQL Developer
- Sql – What’s the difference between RANK() and DENSE_RANK() functions in oracle
- Sql – How to create id with AUTO_INCREMENT on Oracle
- .NET SOA commercial recommendation
Best Answer
From Ask Tom
You should consider a schema to be the user account and collection of all objects therein as a schema for all intents and purposes.
SCOTT is a schema that includes the EMP, DEPT and BONUS tables with various grants, and other stuff.
SYS is a schema that includes tons of tables, views, grants, etc etc etc.
SYSTEM is a schema.....
Technically -- A schema is the set of metadata (data dictionary) used by the database, typically generated using DDL. A schema defines attributes of the database, such as tables, columns, and properties. A database schema is a description of the data in a database.