Re: Datafile info.

See if the file appears in the output of

   select status,name from v$datafile;

How about 'alter system backup controlfile to trace'.

Does the file show up there?

How old is the timestamp on the file?

Jared


On Tue, 16 Nov 2004 15:38:17 -0500, Jaehne, Richard S
<jaehners@xxxxxxxxx> wrote:
> 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
> 


-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l

Other related posts: