• 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.
  • 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.