Re: How to find objects in a Datafile?

From: Douglas Hawthorne <douglashawthorne_at_yahoo.com.au>
Date: Mon, 03 May 2004 12:49:49 GMT
Message-ID: <Ndrlc.9660$TT.8974@news-server.bigpond.net.au>

"Newbie" <learning_still_at_hotmail.com> wrote in message 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.
For information about what is stored where, see "DBA_SEGMENTS" on p.2-220 of "Oracle9i Database Reference".

You may want to review the newsgroup thread, "Compressing emptied User-Datafiles ", at
http://groups.google.com.au/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&frame=right&th=cdb71dcb76b26775&seekm=4084d777.2135751%40news.inet.tele.dk#link1

Douglas Hawthorne Received on Mon May 03 2004 - 07:49:49 CDT