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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
