The concept of user and schema (schema) in Oracle

Database theory in the database user and database schema is not necessarily linked, detailed database schema interpretation can be found here:

Http://stackoverflow.com/questions/2674222/what-is-purpose-of-database-schema

A database schema is a-logically group objects such as tables, views, stored procedures etc. Think of a schema as a container of objects. You can assign a user login permissions to a single schema so that the user can only access the objects they is authorize D to access.

Schemas can is created and altered in a database, and users can is granted access to a schema. A schema can be owned by any user, and schema ownership istransferable.

This means that the database schema can be created and modified, and can be accessed by different users or given to different users.

The explanation in Oracle's document, concepts, is this:

A schemaisa collection of logical structures of data, or schema objects. A Schema is

Owned by a database user and have the same name as that user. Each user owns a single
Schema.

Although the schema in Oracle is also a collection of data objects, here a user corresponds to a pattern that can only be owned by one database user.

Concepts of user and schema in Oracle