Data File

Printable View

06-11-2002, 11:59 AM
siddiqui76

Hi- Anyone can help me looking for what the difference between datafile andtablespace and how they relate to eachother???
06-13-2002, 09:50 AM
ksarav

datafile is a physical structure in a database whereas tablespace is a logical structure.
a tablespace can consists of one or more datafiles.
06-13-2002, 01:08 PM
siddiqui76

Can you specify size for table space that how many data files can be stoerd in one tablespace??
06-14-2002, 09:14 AM
ksarav

the size of the tablespace depends on the size of all the datafiles in the particular tablespace.
a tablespace can have one or more datafiles. this depends upon the "maxdatafiles" u set when u create ur database.
by default the maxdatafiles is 32.
06-18-2002, 12:35 PM
siddiqui76

Thanks Saravan I really appreciate your help...Take Care
07-29-2002, 03:11 PM
kitti2

Quote:

Originally posted by siddiqui76
Hi- Anyone can help me looking for what the difference between datafile andtablespace and how they relate to eachother???

Hi Siddhique,
you are not supposed to ask such a basic question in this site.
Thanks
Kitti
11-19-2002, 03:10 AM
Cetaceans4

Quote:

Originally posted by kitti2
Hi Siddhique,
you are not supposed to ask such a basic question in this site.
Thanks
Kitti

Quote:

Hi Kitti,

Although Siddhique question to you and I may have been extremely basic, I believe that we all had to start somewhere. This is a great forum to communicate thoughts back-in-forth, both for the novice DBA and the Advanced DBA. I know for myself I was once ago at that level, where I needed support.

For Siddhique,

Although extremely late on the reply, *WARNING* having more than one datafile to a tablespace (especially if the tablespace is very dynamic in nature) you will run into some very severe fragmentation problem. Even COALESCE will not help, because of the contiguous space problem.

Rod