Tablespaces
From: ExecMan <artmerar_at_yahoo.com>
Date: Thu, 1 Dec 2011 12:19:40 -0800 (PST)
Message-ID: <716c8dfc-c1fd-4cea-a820-a43e0293b7b2_at_d17g2000yql.googlegroups.com>
Date: Thu, 1 Dec 2011 12:19:40 -0800 (PST)
Message-ID: <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. Received on Thu Dec 01 2011 - 14:19:40 CST