异常原因：
异常场景中导出目录在磁盘组中，oracle用户不具有该目录权限.
解决方案：
将oracle用户的家目录作为导出目录(说明：以下为测试结果).
SQL>create directory oggdump as '/home/oracle/';
Directorycreated.
[oracle@leo~]$ expdp \'/ as sysdba\' directory=oggdump dumpfile=exp%U.dmp logfile=exp.logfull=y FILESIZE=50m
Export:Release 12.1.0.2.0 - Production on Mon Aug 15 20:46:30 2022
Copyright(c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
Connectedto: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bitProduction
With thePartitioning, OLAP, Advanced Analytics and Real Application Testing options
Starting"SYS"."SYS_EXPORT_FULL_01": "/******** AS SYSDBA" directory=oggdump dumpfile=exp%U.dmplogfile=exp.log full=y FILESIZE=50m
Estimatein progress using BLOCKS method...
Processingobject type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Totalestimation using BLOCKS method: 36.5 MB
……
Mastertable "SYS"."SYS_EXPORT_FULL_01" successfullyloaded/unloaded
******************************************************************************
Dump fileset for SYS.SYS_EXPORT_FULL_01 is:
/home/oracle/exp01.dmp
Job"SYS"."SYS_EXPORT_FULL_01" successfully completed at MonAug 15 20:47:44 2022 elapsed 0 00:01:14
[oracle@leo~]$ expdp \'/ as sysdba\' directory=oggdump dumpfile=exp%U.dmp logfile=exp.logfull=y FILESIZE=50m compression=all parallel=8
Export:Release 12.1.0.2.0 - Production on Mon Aug 15 20:50:12 2022
Copyright(c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
Connectedto: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bitProduction
With thePartitioning, OLAP, Advanced Analytics and Real Application Testing options
Starting"SYS"."SYS_EXPORT_FULL_01": "/******** AS SYSDBA" directory=oggdump dumpfile=exp%U.dmplogfile=exp.log full=y FILESIZE=50m compression=all parallel=8
Estimatein progress using BLOCKS method...
Processingobject type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Totalestimation using BLOCKS method: 36.5 MB
. .exported "APEX_030200"."WWV_MIG_FORMS" 0 KB 0 rows
……
Mastertable "SYS"."SYS_EXPORT_FULL_01" successfullyloaded/unloaded
******************************************************************************
Dump fileset for SYS.SYS_EXPORT_FULL_01 is:
/home/oracle/exp01.dmp
/home/oracle/exp02.dmp
/home/oracle/exp03.dmp
/home/oracle/exp04.dmp
/home/oracle/exp05.dmp
/home/oracle/exp06.dmp
/home/oracle/exp07.dmp
Job "SYS"."SYS_EXPORT_FULL_01"successfully completed at Mon Aug 15 20:51:18 2022 elapsed 0 00:01:06
结论：成功执行，生产环境也是如此解决此异常的.
作者: 郑全 时间: 2022-9-8 09:53
EXPDP能否把数据导出到 磁盘组呢，该如何做？
作者: denglj 时间: 2022-10-10 21:01
郑全 发表于 2022-9-8 09:53
EXPDP能否把数据导出到 磁盘组呢，该如何做？
经测试，expdp是可以直接导出到磁盘组的.
http://bbs.cqsztech.com/forum.ph ... id=30230&extra=
| 欢迎光临 重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/) | Powered by Discuz! X3.2 |