RE: What comes first?? (Creating the Database or the Tablespace)
- From: Michael Milligan <Michael.Milligan@xxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 27 May 2004 10:50:52 -0500
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@xxxxxxxxxx]
Sent: Thursday, May 27, 2004 7:25 AM
To: 'oracle-l@xxxxxxxxxxxxx'
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@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
-----------------------------------------------------------------
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.
----------------------------------------------------------------
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:
