Datafile info.

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

--
http://www.freelists.org/webpage/oracle-l