Re: Tablespaces

From: ExecMan <artmerar_at_yahoo.com>
Date: Thu, 1 Dec 2011 13:45:35 -0800 (PST)
Message-ID: <c7edaa3c-9962-4ed1-91ad-0921eb0b571a_at_4g2000yqu.googlegroups.com>

On Dec 1, 3:12 pm, "Jonathan Lewis" <jonat..._at_jlcomp.demon.co.uk> wrote:
> http://jonathanlewis.wordpress.com/2010/02/06/shrink-tablespace/http://jonathanlewis.wordpress.com/tablespace-hwm/
>
> --
> Regards
>
> Jonathan Lewishttp://jonathanlewis.wordpress.com
>
> "ExecMan" <artme..._at_yahoo.com> wrote in message
>
> news:716c8dfc-c1fd-4cea-a820-a43e0293b7b2_at_d17g2000yql.googlegroups.com...
>
>
>
> > 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.

Good article. Very helpful. What does a command like this do?

 alter table SHOPCART_SESSIONS move;

It runs, but what does it do to the table? Rebuild it? Received on Thu Dec 01 2011 - 15:45:35 CST