Did you also check DBA_TEMPFILES for it? It could be a tempfile instead of a data file. Otherwise, it's probably left there by an already dropped tablespace. Check the timestamp on that file. Richard 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