data files are not stored in up case in the data dictionaey SQL> select file_name from dba_data_files 2 / FILE_NAME -------------------------------------------------------------------------------- /u02/oradata/system01.dbf So your query would return nothing (something you could of checked) On Wed, 17 Nov 2004 09:08:15 -0500, Igor Neyman <ineyman@xxxxxxxxxxxxxx> wrote: > > 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 > -- //www.freelists.org/webpage/oracle-l