EXP-00008: ORACLE error 6550 encountered 报错

最新推荐文章于 2024-07-04 10:26:47 发布

make_zhf

最新推荐文章于 2024-07-04 10:26:47 发布

阅读量5.2k

点赞数

分类专栏： oracle 文章标签： oracle 数据库

本文链接：https://blog.csdn.net/make_zhf/article/details/54091070

版权

在尝试使用exp导出数据时遇到EXP-00008错误，可能原因是安全加固导致用户丢失某些权限。解决办法包括向用户授予SYS.DBMS_DEFER_IMPORT_INTERNAL和SYS.DBMS_EXPORT_EXTENSION这两个系统的执行权限。

摘要由CSDN通过智能技术生成

exp user/passwd file=/oracle.bak/data.$(date +%Y-%m-%d).dmp log=/oracle.bak/data.$(date +%Y-%m-%d).log full=y

Connected to: Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)

About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type d