Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between an Oracle Schema and an
Oracle Instance?
- 3 Answers
- 9025 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 |
What is difference between SUBSTR and INSTR?
what is the difference between UNION AND UNIONALL
how to get count of tables in particular database in Oracle?
What are the different pseudo commands? Explain in general?
Which environment variables are absolutely critical in order to run the OUI?
Is java required for oracle client?
9. Display the client name and order date for all orders using the JOIN . . . USING method.
What is clusters ?
how to select second mauximum value in a given table under salary column
How to write numeric literals in oracle?
Please explain joins in oracle?
What is clustered table in Oracle?
Oracle General 
