| 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)
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_at_vicr.com]
Sent: Thursday, May 27, 2004 8:07 AM
To: oracle-l_at_freelists.org
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_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
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.
 |
 |