RE: Datafile info.

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Wed, 17 Nov 2004 09:08:15 -0500
Message-ID: <002001c4ccae$e1f8eee0$2004a8c0@development.perceptron.com>

select TABLESPACE_NAME, BYTES, BLOCKS from DBA_DATAFILES

where FILE_NAME = UPPER('/oracle/dbs/BIG.dbf');

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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
--

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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Nov 17 2004 - 08:12:10 CST