Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Datafile info.

Re: Datafile info.

From: David Sharples <davidsharples_at_gmail.com>
Date: Wed, 17 Nov 2004 14:21:50 +0000
Message-ID: <be592d5504111706217578702e@mail.gmail.com>


data files are not stored in up case in the data dictionaey

SQL> select file_name from dba_data_files   2 /

FILE_NAME



/u02/oradata/system01.dbf

So your query would return nothing (something you could of checked)

On Wed, 17 Nov 2004 09:08:15 -0500, Igor Neyman <ineyman_at_perceptron.com> wrote:
>
> 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
>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US