Thursday, June 23, 2011

Oracle 10g exp problem - EXP-00008: ORACLE error 6550 encountered, ORA-06550: line 1, column 13

Use Case

During exp following error occured:

EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 13:
PLS-00201: identifier 'EXFSYS.DBMS_EXPFIL_DEPASEXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling EXFSYS.DBMS_EXPFIL_DEPASEXP.schema_info_exp
. exporting statistics
Export terminated successfully with warnings.


Please, follow these steps:

1. Connect as SYS using SQL*Plus

@ ?/rdbms/admin/catexf.sql

Now, if EXFSYS schema is not created look into log files and search for any errors.

Another helpful link:

No comments:

Post a Comment