Home » Server Options » Replication » Error Whle Refreshing Materialized View---Very Urgent
Error Whle Refreshing Materialized View---Very Urgent [message #75612] Fri, 04 February 2005 21:38
Sreedhar Reddy
Messages: 55
Registered: January 2002
Materialized view geeting updated sucessfully through OEM ( Oracle Enterprise Manager through Wahrehouse options)

but it fails at SQL Prompt.....

SQL> exec dbms_mview.refresh('mtransactions');
BEGIN dbms_mview.refresh('mtransactions'); END;

ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_DEFER_SYS" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 794
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 851
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 832
ORA-06512: at line 1
Previous Topic: oracle 9i replication
Next Topic: deleted repgroup but it is showing in DBA_REPOBJECT.URGENT PL.
Goto Forum:

Current Time: Sat Nov 28 05:37:43 CST 2015

Total time taken to generate the page: 0.07849 seconds