Re: How to find objects in a Datafile?

From: rs <info_at_NSPAMbytelife.com>
Date: Wed, 5 May 2004 15:58:06 +0200
Message-ID: <4098f2f3$0$60787$cd19a363@news.wanadoo.nl>

hello,
Just run the frag.sql script from http://www.bytelife.com/sql4dba.htm to find out where the objects in the datafile are. Move the objects and then u can resize the datafile.

good luck,

Roelof Schierbeek

"Newbie" <learning_still_at_hotmail.com> schreef in bericht news:6093c29e.0405030424.707c0c4_at_posting.google.com...
> Hi,
>
> Can we find what all objects lie in a datafile?
>
> I have 3 datafiles mapped to a tbsp, out of which 1 has become really
> HUUGE =~ 24GB. Datafile usage in OEM shows a measly 0.5% full.
> Resizing the datafile says "file contains used data beyond requested
> RESIZE value".
>
> Please suggest what to do in this situation.
>
> TIA.
Received on Wed May 05 2004 - 08:58:06 CDT