Oracle/diff between instance,schema,database
Hi Peter Choi,
i am using oracle 10g(rdbms). i am beginer in plsql,mostly iam confusing with this words schema,database,context could you please explain me the diff between those three briefly?
In Oracle (since inception), a schema is a collection of objects managed under a user account.
In a default Oracle installation, you can choose to install the sample user SCOTT which owns a few tables (EMP, DEPT, etc.). SCOTT is a SCHEMA.
There are other administrator type schemas that are installed that is used to manage the database instance.
A database is made of the "database repository", the structures that contain data, and an "instance". The instance represents all the background processes that support and make up the database. Thus to create a database, you first need to create the instance. Then that will allow you to create your database. Once your database is created, you can create your schema, which will then allow you to create the structures and objects to store (e.g. tables) and process (e.g. PL/SQL stored procedures) data.
I hope this clarifies the terminologies.