Home » SQL & PL/SQL » SQL & PL/SQL » Schema or Instance
Schema or Instance [message #328353] Thu, 19 June 2008 18:28 Go to next message
florida
Messages: 82
Registered: April 2006
Member
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.
Re: Schema or Instance [message #328355 is a reply to message #328353] Thu, 19 June 2008 18:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> I assume I just need a Schema in Oracle and not a new instance (SID)?
Thats right, in most cases. Very specific requirements (like certain compliance) may require a separate instance.
>>an instance means I need alot more storage space
And designated area in memory, generally more resources.
Re: Schema or Instance [message #328372 is a reply to message #328353] Thu, 19 June 2008 23:16 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I advise you to read Oracle Database Concepts

Regards
Michel
Previous Topic: Check completion status from log table
Next Topic: varray, snapshot
Goto Forum:
  


Current Time: Thu Dec 08 12:26:25 CST 2016

Total time taken to generate the page: 0.09856 seconds