| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
