Datafile info.

From: "Jaehne, Richard S" <JaehneRS@xxxxxxxxx>
To: "'Oracle-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 16 Nov 2004 15:38:17 -0500

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

Follow-Ups:

Re: Datafile info.
From: David Sharples

Re: Datafile info.
From: Richard Ji

Re: Datafile info.
From: Jared Still

RE: Datafile info.
From: Igor Neyman

Datafile info.

Other related posts: