What is the difference between an Oracle Schema and an
Oracle Instance?
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 the output of select * from emp where null=null & select * from emp where 1=1
Is insert autocommit in oracle?
What operating systems are supported by oracle database 10g xe?
What is Trace File ?
Can we write dml statement in function in oracle?
how many types of index?
Which Oracle App Is Most Popular One ?
How to compare dates in oracle sql?
master table and child table performances and comparisons in Oracle ?
How to rename an existing table?
Describe Referential Integrity ?
How to use an explicit cursor without open statements?