| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: What comes first?? (Creating the Database or the Tablespace)
Well, it is sort of a chicken & egg thing. When you issue the "create =
database" command the system tablespace gets created for you at the same =
time. You can't create the system tablespace anyway else. Mind you, =
you can drop it, with subsequent catastrophic results. Once the "create =
database" command finishes you can create any other tablespace(s) you =
want. I'd strongly recommend either a beginners class on Oracle =
followed by the beginners and intermediate DBA classes or the Oracle for =
Dummy's book at Amazon.com. You need a basic understanding of what your =
talking about, otherwise Mladen is going to have your lunch.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Software Software [mailto:SoftwareS_at_aamines.co.zw]
Sent: Thursday, May 27, 2004 7:42 AM
To: 'oracle-l_at_freelists.org'
Subject: What comes first?? (Creating the Database or the Tablespace)
Hie All,
I would like to find out from you what should be created first between =
the
database and the tablespace? The book I managed to lay my hands on does =
not
say, and I'm lost as what should I create first.
Also does the database use the same datafile as the tablespace?
TIA
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |