EXP-00056: ORACLE error 6550 encountered报错;

SQL> exp sys/sys file=/home/oracle/sys.dmp full=y

Export: Release 11.2.0.3.0 - Production on Wed Apr 30 16:53:47 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

EXP-00056: ORACLE error 6550 encountered

ORA-06550: line 1, column 15:

PLS-00201: identifier 'SYS.DBMS_EXPORT_EXTENSION' must be declared

ORA-06550: line 1, column 15:

PL/SQL: Statement ignored

EXP-00000: Export terminated unsuccessfully

执行安全加固后部分权限丢失;

通过以下方法解决:

GRANT EXECUTE ON SYS.DBMS_DEFER_IMPORT_INTERNAL TO <user_name>;

GRANT EXECUTE ON SYS.DBMS_EXPORT_EXTENSION TO <user_name>;

上一篇:IMP-00058: ORACLE error 1882 encountered


下一篇:oracle解决导入高版本dmp报错问题:IMP-00058: ORACLE error 12547 encountered