select TABLESPACE_NAME, BYTES, BLOCKS from DBA_DATAFILES where FILE_NAME = UPPER('/oracle/dbs/BIG.dbf'); Igor Neyman, OCP DBA ineyman@xxxxxxxxxxxxxx -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jaehne, Richard S Sent: Tuesday, November 16, 2004 3:38 PM To: 'Oracle-L (E-mail) Subject: 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 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l