Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00604: error occurred at recursive SQL level 1 and ORA-30036:

652811Oct 13 2009 — edited Oct 13 2009

Hi Gurus,

I am trying to shrink the table segment along with indexes.
I am using
alter table OWNER.TABLE shrink space cascade; syntax but after 1 hr i got the following error.

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-30036: unable to extend segment by 4 in undo tablespace 'UNDOTBS01'

UNDO tablespace has sufficient space and undo_retention is 6Hrs. What could be the problem ?

Or do i need to use
alter table OWNER.TABLE shrink space; only ?

Thanks & Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 10 2009

Added on Oct 13 2009

#general-database-discussions, #problem

5 comments

1,253 views