Re: Tablespaces
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 1 Dec 2011 21:12:57 -0000
Message-ID: <tNidnXUXKulFcErTnZ2dnUVZ7vqdnZ2d_at_bt.com>
Date: Thu, 1 Dec 2011 21:12:57 -0000
Message-ID: <tNidnXUXKulFcErTnZ2dnUVZ7vqdnZ2d_at_bt.com>
http://jonathanlewis.wordpress.com/2010/02/06/shrink-tablespace/ http://jonathanlewis.wordpress.com/tablespace-hwm/
-- Regards Jonathan Lewis http://jonathanlewis.wordpress.com "ExecMan" <artmerar_at_yahoo.com> wrote in message news:716c8dfc-c1fd-4cea-a820-a43e0293b7b2_at_d17g2000yql.googlegroups.com...Received on Thu Dec 01 2011 - 15:12:57 CST
>
> So, one tries to resize a datafile and receives the ORA-03297 error.
> In our case, we have nearly 2000 tables in the tablespace.
>
> Short of moving them all elsewhere, or doing an export / import, is
> there any way to see WHAT objects may be above the size limit we are
> trying to shrink to, and move only those objects? I'm not sure how to
> actually map that out.
>
> Just curious.