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.

Solution

Please, follow these steps:

1. Connect as SYS using SQL*Plus

2. Run CATEXF.SYS
@ ?/rdbms/admin/catexf.sql


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

Another helpful link: http://oracle-in-examples.blogspot.com/2008/03/exp-00008-oracle-error-6550-encountered.html

No comments:

Post a Comment