RE: What comes first?? (Creating the Database or the Tablespace)
- From: "Goulet, Dick" <DGoulet@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 27 May 2004 09:07:12 -0400
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@xxxxxxxxxxxxx]
Sent: Thursday, May 27, 2004 7:42 AM
To: 'oracle-l@xxxxxxxxxxxxx'
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
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
