Hi,
If i have a two datafiles in a tablespace, is it possible to find out in which datafile my table is created.
Printable View
Hi,
If i have a two datafiles in a tablespace, is it possible to find out in which datafile my table is created.
DBA_EXTENTS.File_Id column will give you datafile number.Quote:
Originally posted by bang_dba
If i have a two datafiles in a tablespace, is it possible to find out in which datafile my table is created.
Sameer
but it may be in both if there is more than 1 extent.