Re: Undo Tablespace growing even with retention = 0

Jagjeet Singh wrote:
> Hi All,
>
> Can you please help me to understand this.
> I have set created new undo tablespace of 4 mb on my test database.
>
> I set undo_retention = 0 and was updateding a table with 1 records and
> commiting each time.
> But still my undo tablespace is growing.
>
> here is the test case
>
> Regards,
> Jagjeet Singh

Why would you expect behaviour to be different? Setting retention to 0 is more likely to guarantee an ORA-01555 than anything else. A 4MB UNDO tablespace is preposterously small. What is the point of what you are doing? Is there a business case hidden here somewhere or are you just playing around for purposes of personal education?

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