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!

Issue in Complete Refresh of a Materialized View

595765Sep 21 2009 — edited Sep 22 2009

Hello,

We have an MV in the Datawarehouse that does a FAST REFRESH daily. Every Saturday, a COMPLETE REFRESH is done as part of the normal Database Activities. The Database is Oracle 9i. The MV contains a Join between a Dimension and Fact Table of a Datawarehouse and does a FAST REFRESH using the MV logs.

However, last Sat, the COMPLETE REFRESH has failed. The DBA tried to run the script twice again but it failed on both occasions with an UNDO TABLESPACE error (ORA-30036). The DBA tried to extend the Tablespace; it did not help either.

- Could this be linked to Tablespace allocations for the MV? Are there any specific steps that can be followed to resolve this?

- Can the MV be dropped and re-created?

Would appreciate a response on the same.

Many Thanks,
Ketan

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 20 2009

Added on Sep 21 2009

#general-database-discussions, #refresh

5 comments

710 views