Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between an Oracle Schema and an
Oracle Instance?
- 3 Answers
- 9029 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 can you merge two tables in oracle?
Explain what does a control file contain?
How to create a stored function in oracle?
what are the disadvantages of hierarchial database over RDBMS?
What is a data segment ?
How to find the date and time of last updated table?
Display the order number and the number of months since the order was shipped for all orders that have been shipped in the last year (365 days). (Hint: Unshipped orders will have a null value).
what are the default admin accounts in Oracle 10g ?
What is pragma autonomous transaction in oracle?
what are the advantages of running a database in archive log mode?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
waht is referencial integrity?
Oracle General 
