Re: How to find out the segments (whether it is table or index) at the end of each datafile in a tablespace.

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 27 Nov 2011 09:58:12 -0000
Message-ID: <85FB9507655C4EDA8CB79FF5655FCD4A_at_Primary>

Anurag,

Dave Herring has already supplied a suitable example of a script. If you want some extra thoughts I wrote about the problem at the following URL:

http://jonathanlewis.wordpress.com/2010/02/06/shrink-tablespace/

Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Original Message ----- From: "Anurag Verma" <anuragdba_at_gmail.com> To: "ORACLE-L" <oracle-l_at_freelists.org> Sent: Sunday, November 27, 2011 3:48 AM Subject: How to find out the segments (whether it is table or index) at the end of each datafile in a tablespace.

how to find out the segments (whether it is table or index) at the end of each datafile in a tablespace.
I am trying to reduce the sizes of several datafiles, but getting the below error message.

--

http://www.freelists.org/webpage/oracle-l Received on Sun Nov 27 2011 - 03:58:12 CST

This message: [ Message body ]
Next message: Dennis Williams: "Re: Technical illustrations"
Previous message: D'Hooge Freek: "RE: lgwr/dbw0 did not issue pwrite64 sys call"
In reply to: Anurag Verma: "How to find out the segments (whether it is table or index) at the end of each datafile in a tablespace."
Next in thread: Denis: "Re: How to find out the segments (whether it is table or index) at the end of each datafile in a tablespace."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message