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!

Snapshot Refresh (How to stop COMPLETE refresh and run FAST refresh)?

skyfoxJun 3 2011 — edited Jun 3 2011

Hi,

I have a snapshot refresh executed as COMPLETE which is taking very long. When I try to kill this and try to run a FAST I get:

ERROR at line 1:
ORA-12057: materialized view "PORTALSNP1"."V21_BILLING_ACCOUNT" is INVALID an must complete refresh

How can I resolve this to stop the COMPLETE refresh altogether and be able to run the FAST refresh.

Also is there a way to get the time it will take to complete the running snapshot refresh?

Please and thankYou!

Regards,

A

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 1 2011

Added on Jun 3 2011

#general-database-discussions

1 comment

361 views