Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_state.gov> 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-lReceived on Tue Nov 16 2004 - 16:26:20 CST
![]() |
![]() |