Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between an Oracle Schema and an
Oracle Instance?
- 3 Answers
- 9037 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 are the different editions of oracle?
Please explain oracle left join with an example?
why pl sql doesn't support retrieving multiple records
How can we find the size of a database?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
what is the difference between rollback & commit? can a foreign key has null value?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
What suggestions do you have to reduce the network traffic?
What is the parameter mode that can be passed to a procedure?
What is sequence?
How will you write a query to get a 5th rank student from a table student_report?
What happens if recursive calls get out of control?
Oracle General 
