RE: Datafile info.
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'JaehneRS@xxxxxxxxx'" <JaehneRS@xxxxxxxxx>, "'Oracle-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 18 Nov 2004 08:25:34 -0500
Richard,
The problem could simply be spelling or upper/lower case issues.
Try running the following and see what you get:
select TABLESPACE_NAME, BYTES, BLOCKS from DBA_DATAFILES
/
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Jaehne, Richard S [mailto:JaehneRS@xxxxxxxxx]
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
Other related posts:
