Re: Tablespaces

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 1 Dec 2011 21:44:50 +0000 (UTC)
Message-ID: <pan.2011.12.01.21.44.50_at_gmail.com>

On Thu, 01 Dec 2011 12:19:40 -0800, ExecMan wrote:

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

As Jonathan has pointed out, you can find out the requested information from DBA_EXTENTS view. Are you really sure that you want to do that? If that is a used and alive tablespace, the space is likely to be needed again, in which case you will take a performance hit, possibly a big one, too.

-- 
http://mgogala.byethost5.com

Received on Thu Dec 01 2011 - 15:44:50 CST