Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between an Oracle Schema and an
Oracle Instance?
- 3 Answers
- 9018 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
What operating systems are supported by oracle database 10g xe?
How to resolve name conflicts between variables and columns?
Is there any function in oracle similar like group_concat of mysql?
Give the different types of rollback segments.
How to get execution statistics reports on query statements?
Why do you use stored procedures and state some of its disadvantages?
How to assign a table row to a record variable?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How to set a transaction to be read only in oracle?
Explain the use of compress option in exp command.
what are actual and formal parameters?
What are the built-in functions used for sending Parameters to forms ?
How do I find my oracle client driver version?
what is the difference between data migration and production migration.
How to write numeric literals in oracle?
