Schema defines the over all structure of the database. In general, schema defines the tables, the fields in each table, and the relationships between fields and tables. Schema will be stored in a data dictionary. From Oracle website: A schema is a collection of database objects. A schema is owned by a database user and … Read more