Refreshing a materialised view -FAST and COMPLETE
ORA-12012: error on auto execute of job **ORA-12048:
error encountered while refreshing materialized view
"GENESIS"."RA_CUST_RELATE"
ORA-12057: materialized view or zonemap
"GENESIS"."RA_CUST_RELAT" is invalid and must use complete
refresh
Need to perform Complete refresh for one time, later it can
be FAST refreshed large snapshot We may want to run it in parallel mode.
execute dbms_snapshot.refresh (LIST=>'RA_CUST_RELATE '
,PARALLELISM=>4, METHOD=>'C');
No comments:
Post a Comment