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)
Hi Software Software,
with all due respect, I think you need to take some sort of elementary
training ...
anyway, to answer your questions:
you cannot create a tablespace without having created a database first, and having started an instance against that database.
datafiles are associated with tablespaces, and tablespaces belong to databases.
I have this feeling you have some misconception about the term "tablespace" in Oracle -- I know other vendors use the same term, but with a completely different meaning ...
hope this helps,
Lex.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Software Software
Sent: Thursday, May 27, 2004 12:42
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
![]() |
![]() |