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
Member
Materialized view geeting updated sucessfully through OEM ( Oracle Enterprise Manager through Wahrehouse options)

but it fails at SQL Prompt.....
Help......

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: Fri Mar 29 06:05:28 CDT 2024