What is the difference between an Oracle Schema and an
Oracle Instance?
- 3 Answers
- 8317 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
How to define an external table with a text file?
How to pass a parameter to a cursor in oracle?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
How index is implemented in oracle database?
Design database draw er diagram for a certain scenario ?
What is the quickest way to fetch the data from a table?
What is enter substitution variable in oracle?
What is an oracle function?
What is a sub query and what are the different types of subqueries?
Will you be able to store pictures in the database?explain.
Explain the difference between a procedure and a function?
How to invoke the original export import utilities?
What are the restrictions on external table columns?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
