RE: Datafile info.

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Thu, 18 Nov 2004 08:25:34 -0500
Message-ID: <C9995D8C5E0DDA4A8FF9D68EE666CE0702A97058@exchsen0a1ma>

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_at_state.gov] 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
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Thu Nov 18 2004 - 07:30:22 CST