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
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
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
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