Need new Schema not Instance?

[cleanair4me]

I am transferring an Access 2003 database that is around 20 MB in size to our Oracle 9i Database. I assume I just need a Schema in Oracle and not a new instance (SID)? I need around 20-30 MB size in Oracle database. For what I understand an instance means I need alot more storage space so in my case I just need a new Schema?

Please advise.

 

[Jacob06]

In oracle world instance means database just like access database. What is the storage capacity of your sever? schema are like user in access database. so you create schema or user in the oracle database.

 

[SantaMufasa]

I assume I just need a Schema in Oracle and not a new instance

Correct.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
A fo ben, bid bont.

 

[cleanair4me]

Thank you.

 

[taupirho]

Putting on my nitpicking hat here but just to be clear that in Oracle the instance is in fact not the database although it depends from what semantic viewpoint you're coming from I guess. I think more formally though the database is the set of files - redo, data, control etc ... that make up - well the database! Informally I think when people (me anyway) refer to a database we're thinking of the schema i.e the tables,indexes and so on

The instance on the other hand is more formally the processes and memory used to manage one or more databases in general, such as the database writer, the SGA etc ...


In order to understand recursion, you must first understand recursion.

 

[SantaMufasa]

Absolutely correct, Taupirho. (Good clarification.)

Another way to think about it is:

Oracle Instance: What disappears when the electricity goes off.

Oracle Database: What remains after the electricity goes off (you simply can't access the database without electricity <grin>).

Oracle generally stands alone in the database world in its nomenclature for a database. Roughly...

Oracle's Schema = Rest of World's Database.
Oracle's Database = Rest of World's Combination of all Database's under management of a single database engine/instance.

Hopefully, this helps to distinguish and define Oracle's nomenclature departure from the rest of the industry.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
A fo ben, bid bont.