What is the difference between an Oracle Schema and an
Oracle Instance?
Answer Posted / 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 |
Post New Answer View All Answers
What is the oracle implicit cursor?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
How to create lov dynamically at runtime & attach to text field?
What is translate in oracle?
How to import one table back from a dump file?
Explain drop constraint oracle?
How to create a single index for multiple columns?
When system tablespace is created?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How to grant create session privilege to a user in oracle?
How to create a new oracle data file?
How to resolve name conflicts between variables and columns?
What is an oracle function?
What is recovery manager(rman) backup in Oracle?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?