What is the difference between an Oracle Schema and an
Oracle Instance?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you merge two tables in oracle?

565


How to use values from other tables in update statements using oracle?

564


What happens if you use a wrong connect identifier?

499


How to install oracle database 10g xe?

560


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??

1364






What is a proxy class?

555


Explain database link?

660


How does one get the view definition of fixed views/tables?

594


How to define a variable to match a table column data type?

576


What is dynamic proxy?

547


Explain a private synonyms?

630


How to use subqueries with the exists operator in oracle?

604


Difference between inner join vs where ?

607


How do I uninstall oracle 11g?

553


1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1578