for simplicity, Instance is the name of the Database. Schema is the owner

What is the difference between an Oracle Schema and an
Oracle Instance?

Question Posted / vishal

3 Answers
8857 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / vishal

for simplicity, Instance is the name of the Database.
Schema is the owner of your objects(tables, indexes, views,
synonyms,etc).

In you example, you have a Database Instance named
CONTRACT.

In your Contract database, you have 2 Schemas named LEGAL &
RI

Is This Answer Correct ?

6 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to create an oracle testing table?

1005

Difference between cartesian join and cross join?

955

does the query needs a hint to access a materialized view?

1811

What is Reduced List of Values?

2098

What is a directory object?

1022

What is system global area (sga) in oracle?

925

Is primary key indexed by default in oracle?

928

What is the oracle implicit cursor?

994

How to increment dates by 1 in oracle?

989

Will you be able to store pictures in the database?

1061

What is the fastest query method to fetch data from the table?

1290

Is the After report trigger fired if the report execution fails ?

2874

How do I manually create a database in oracle?

952

What are the benefits of ordbms?

1023

What is oracle used for?

966