Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between an Oracle Schema and an
Oracle Instance?
- 3 Answers
- 8996 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 |
Differnce between view and index
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What is meant by an index?
why dont we assign not null constraint as table level constraint.
Can you drop an index associated with a unique or primary key constraint?
What is the string concatenation operator in oracle?
Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.
How to estimate disk space needed for an export job?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
how will I find the first 5 highest salaried employees in each dept in oracle.
What are the restrictions in a oracle read only transaction?
What is user managed backup in Oracle?
Oracle General 
