Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between an Oracle Schema and an
Oracle Instance?
- 3 Answers
- 9000 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 is the scenario where you take the database to NoArchivelog mode?
Difference between the “verify” and “feedback” command?
What is the recommended interval at which to run statspack snapshots, and why?
List the parts of a database trigger.
What do you mean by a deadlock?
What's dateware house and what's clustor with practicle example
How to define a variable to match a table column data type?
What are the general rules on data consistency?
Name the various constraints used in oracle?
how to join query for one source type is oracle another source type is sql server ?
Why do we need oracle client?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
Can group functions be mixed with non-group selection fields?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
What are the differences between date and timestamp in oracle?
