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!

Materialized View refresh causes ORA-30036 (unable to extend...undo)

cimincJun 22 2009 — edited Jun 22 2009

10gR2
* no retention guarantee
* autoextend is off
* materialized view and indexes are set for nologging
* materialized view is set for complete refresh (materializes a pipelined table from a function)
* 11GB of undotbs
* Undo Tablespace Usage in EM shows most of the 11GB to be allocated in Retention....nothing is typically in use by transaction

Is there a way to determine how much space the dbms_mview.refresh is using? Any hints of what I should be looking for at this point would be appreciated. I'm going to run again, but watch the Undo Tablespace Usage, perhaps I'll get more info that way.

Thanks,
Phil

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 20 2009

Added on Jun 22 2009

#general-database-discussions

2 comments

1,029 views