Data File

[siddiqui76]

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

[ksarav]

datafile is a physical structure in a database whereas tablespace is a logical structure.
a tablespace can consists of one or more datafiles.

[siddiqui76]

Can you specify size for table space that how many data files can be stoerd in one tablespace??

[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.

[siddiqui76]

Thanks Saravan I really appreciate your help...Take Care

[kitti2]

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

[Cetaceans4]

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

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