Re: ORA-01555 when trying to DROP TABLESPACE

From: Mladen Gogala <mgogala.SPAM_ME.NOT_at_verizon.net>
Date: Thu, 08 Feb 2007 05:27:54 GMT
Message-ID: <uxyyh.9145$xu4.6918@trndny04>

On Wed, 07 Feb 2007 11:23:26 -0800, steven_nospam at Yahoo! Canada wrote:

> Sure enough - increasing the UNDO_RETENTION to 600 allowed the
> tablespace to be dropped without errors. I think the problem is I
> misunderstood the way the UNDO_RETENTION works. I thought that this
> was the minimum amount of time in seconds that the undo data would be
> retained before it could be re-used.

That is correct - provided you have enough space. There is no guarantee. The way to drop the tablespace is to offline it first. That will prevent UNDO generation for the objects within the tablespace.

-- 
http://www.mladen-gogala.com

Received on Wed Feb 07 2007 - 23:27:54 CST