Re: UNDOTBS

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 07 Aug 2006 20:25:46 -0700
Message-ID: <1155007535.308544@bubbleator.drizzle.com>

aprinsloo_at_sagetelecom.net wrote:
> Oracle 9i env, tbs is in MANUAL management mode and auto extend is off.
>
> We have a large update script which filled up about 80% of a 20G
> UNDOTBS. The script crashed and we plan to reload the schema from a
> backup and run the script again, however the UNDOTBS is still sitting
> at 80% full.
>
> Will Oracle know that this rollback data in the UNDOTBS is not required
> and start over writing it when we run the update script again, or do we
> need to perform some manual intervention to "flush" this data?
>
> We dont want to rerun the update script and have it fail becaues the
> UNDOTBS tablespace fills up.
>
> Thx in advance.

If you have MANUAL you don't have an UNDO tablespace: You have rollback segments: Validate your environment.

SQL> SELECT value FROM gv$parameter

   2 WHERE name LIKE '%undo%';

VALUE

---

AUTO
UNDOTBS1
1800

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Mon Aug 07 2006 - 22:25:46 CDT