Go to this book: = http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524.pdf It describes in detail the relationship between databases, tablespaces, = datafiles, blocks etc. You will have to register for a free membership at Oracle Technology = Network. All the books are there from most basic to advanced. > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Software Software > Sent: Thursday, May 27, 2004 7:42 AM > To: 'oracle-l@xxxxxxxxxxxxx' > Subject: What comes first?? (Creating the Database or the Tablespace) >=20 >=20 > Hie All, > I would like to find out from you what should be created=20 > first between the > database and the tablespace? The book I managed to lay my=20 > 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? >=20 > 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 > ----------------------------------------------------------------- >=20 ---------------------------------------------------------------- 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 -----------------------------------------------------------------