Did you try selecting from DBA_TEMPFILES as well? The tablespace may even be
dropped. Try seeng if anybody has the file open with fuser or lsof. You can
also try catching it with "strings controlfile.ctl|grep bigfile". If nobody
is
using it, you can remove it.
--
Mladen Gogala
A & E TV Network
Ext. 1216
> -----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
>
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 16 2004 - 16:09:45 CST
