RE: What comes first?? (Creating the Database or the Tablespace)
- From: April Wells <AWells@xxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 27 May 2004 08:25:24 -0500
There is a really good book... DBA 101... that can also be found on Amazon!
=)
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
@>-->-->--
"Few people really enjoy the simple pleasure of flying a kite"
Adam Wells age 11
"Imagination is the highest kite one can fly."
Lauren Bacall
-----Original Message-----
From: Goulet, Dick [mailto:DGoulet@xxxxxxxx]
Sent: Thursday, May 27, 2004 8:07 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: 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@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
-----------------------------------------------------------------
The information contained in this communication,
including attachments, is strictly confidential
and for the intended use of the addressee only;
it may also contain proprietary, price sensitive,
or legally privileged information. Notice is hereby
given that any disclosure, distribution, dissemination,
use, or copying of the information by anyone other
than the intended recipient is strictly prohibited
and may be illegal. If you have received this communication
in error, please notify the sender immediately by
reply e-mail, delete this communication, and destroy
all copies.
Corporate Systems, Inc. has taken reasonable precautions
to ensure that any attachment to this e-mail has been
swept for viruses. We specifically disclaim all liability
and will accept no responsibility for damage sustained
as a result of software viruses and advise you to carry
out your own virus checks before opening any attachment.
----------------------------------------------------------------
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:
