Symptoms of the Error:
-----------------------------
UDE-00008: operation generated ORACLE error 6550
ORA-06550: line 1, column 56:
PLS-00905: object SYS.DBMS_DATAPUMP is invalid
Cause:
------------------
SYS.DBMS_DATAPUMP is inavlid.
SQL> alter package SYS.DBMS_DATAPUMP compile;
Warning: Package altered with compilation errors.
SQL> show errors
Solution:
---------------
To implement the solution, execute the following steps:
SQL> connect / as sysdba;
SQL> startup upgrade;
SQL> @catalog.sql <--------------$ORACLE_HOME/rdbms/adminSQL> @catproc.sql <--------------$ORACLE_HOME/rdbms/admin
No comments:
Post a Comment