Re: datafile

From: Greg Vitetzakis <ggv007_at_hotmail.com>
Date: Sun, 21 Mar 1999 07:57:38 -0500
Message-ID: <7d2qn0$r9p@tandem.CAM.ORG>

The datafile is the Physical File on which a Tablespace resides on. A tablespace can span over
several datafiles. A tablespace cannot exist onless theirs a datafile unless you use raw devices
as oppose to a file system.

Tables are created and they reside on one tablespace and only one tablespace. If you don't
mention which tablespace it will use the default tablespace that is associated to the user
lauching the create table ... command.

Hope this clears things up a bit.

Greg

Denis wrote in message <01be7393$db501d40$5a5167cf_at_95-mariandc>...
>I would like to make a clear understanding of the datafile in the create
>database. What would be the role of the datafile in the create statement?
>If I place the the datafile as an option in the create DB statement, does
>this mean that my data won't reside in a tablespace? And if I created a
>tablespace for the tables, then what would be inside the datafile that I
>defined during the create statement.
>
>Sorry for so many questions.
>
>TIA,
>
>Denis
Received on Sun Mar 21 1999 - 06:57:38 CST