maybe its a temp file, look in dba_temp_files On Tue, 16 Nov 2004 15:38:17 -0500, Jaehne, Richard S <jaehners@xxxxxxxxx> wrote: > All,=20 > > I've got a large (4G.) datafile let's call him BIG.dbf on one of my = > database servers that I'm not sure what's living in it. =20 > > I did run the following sql statement: > > SQL> select TABLESPACE_NAME, BYTES, BLOCKS from DBA_DATAFILES > 2 where FILE_NAME =3D '/oracle/dbs/BIG.dbf'; > > no rows selected > > Does this mean that this is an empty file? I'm a little puzzled. > > Thanks,=20 > > Richard Jaehne > -- > //www.freelists.org/webpage/oracle-l > -- //www.freelists.org/webpage/oracle-l