How to differentiate users and patterns in Oracle

Oracle users are an important concept in Oracle databases, and here's a look at the differences between Oracle users and schemas, and hopefully help you learn from Oracle users. Recommended Learning Tutorials Yet Silicon Valley Oracle Video Tutorial

(a) What Oracle calls user

(ii) what is schema (schema)
Schema objects is the logical structures That's directly refer to the database ' s data.
mode is a collection of database objects. A schema object is a logical structure of database data.

(c) The difference between the user and the schema (schema):
Schemas and users help Database administrators manage database security.
(but DB2 is different, DB2 a user can correspond to multiple modes, DB2 user is the system, He must first obtain the system user to become the database user, namely the database user is the system user, only the pattern is the database similar user. Interested to be able to study. This is not a topic, this is also DB2 special).

A user has a default schema, whose schema name is equal to the user name, and of course a user can use other schemas. If we visit a table and do not indicate which schema the table belongs to, the system automatically adds the default Sheman name to the table. For example, when we access the database, we access the EMP table under the Scott user, through the select * from EMP; In fact, the complete syntax for this SQL statement is select * from Scott.emp. The full name of an object in the database is Schema.object, not user.object. Similar if we do not specify the schema of the object when creating the object, the schema of the object is the user's default schema. This is like a user with a default tablespace, but the user can also use other tablespaces, and if we do not specify a tablespace when we create the object, the object is stored in the default tablespace, and in order for the object to be stored in another table space, we need to specify the table space for the object when it is created.

More knowledge of database Tutorials can be found in e-mentor network learning.

How to differentiate users and patterns in Oracle