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>
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