| 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)
A lot of books do not give even the rationales that have been given in this
thread. I would go to Borders or Barnes & Noble, look at several beginning
Oracle 9i books, and look up how they explain database creation. Many books
just skip over important things like that, out of laziness. There are a lot
of bad Oracle books out there. We ought to have a thread on most useful and
most usless Oracle books.
-----Original Message-----
From: April Wells [mailto:AWells_at_csedge.com]
Sent: Thursday, May 27, 2004 7:25 AM
To: 'oracle-l_at_freelists.org'
Subject: 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.
This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.
 |
 |