NoName, If you can find a way to create a tablespace before creating a database, then please let us all know how you did it. That kind of information would be worth $millions. Tom Mercadante Oracle Certified Professional -----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 -----------------------------------------------------------------