Monday, April 7, 2008

UDE-00008, ORA-06550 and PLS-00905 When Using Datapump

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