RE: Datafile info.
- From: "Gogala, Mladen" <Mladen.Gogala@xxxxxxxx>
- To: "'JaehneRS@xxxxxxxxx'" <JaehneRS@xxxxxxxxx>, "'Oracle-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 16 Nov 2004 16:42:57 -0500
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@xxxxxxxxx]
> 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
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
