Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between an Oracle Schema and an
Oracle Instance?
- 3 Answers
- 9134 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
Why do you create or replace procedures rather that drop and recreate.
Explain an extent?
How to call a stored function in oracle?
How to use null as conditions in oracle?
How to run the anonymous block again?
What is the use of file param in imp command?
Why oracle is used?
How to define a data source name (dsn) in odbc manager?
Explain the importance of .pll extension in oracle?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
Design database draw er diagram for a certain scenario ?
What privilege is needed for a user to query tables in another schema?
Name the three major set of files on disk that compose a database in Oracle?
How to commit the current transaction in oracle?
Please explain oracle data types with examples?
