Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between an Oracle Schema and an
Oracle Instance?
- 3 Answers
- 8859 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / saiprasannach89
A user in oracle database is called as schema.Objects created by user is called schema objects.
| Is This Answer Correct ? | 7 Yes | 5 No |
Answer / udayah shankar dokku
oracle schema: generally it is static,having tablr
name,column name & associated datatypes
oracle instance : generelly it is dynamic,at ay instance of
time the collection of all records is called oracle instance
| Is This Answer Correct ? | 2 Yes | 0 No |
How to filter out duplications in the returning rows using oracle?
what happened to the global index when I truncate the data in one of the partition?
Briefly explain what is literal? Give an example where it can be used?
what is candidate key & super key
How to call a stored function in oracle?
What is a Sequence ?
does the query needs a hint to access a materialized view?
How do I find the database name in oracle?
What are the built-in functions used for sending Parameters to forms ?
20. Using a set operator, display the client number of all clients who have never placed an order.
Difference between NO DATA FOUND and %NOTFOUND?
What are the different types of failures that occur in Oracle database?
Oracle General 
