这篇文章将为大家详细讲解有关expdp导出数据时候出现报错怎么办，小编觉得挺实用的，因此分享给大家做个参考，希望大家阅读完这篇文章后可以有所收获。
expdp导出数据时候出现报错如下：
[甲骨文@ JX RAC 1 exp _ dir]$ ex PDP系统/Ora _ 123654 ABC目录=cis _ dir schemas=jxcmsuer转储文件=jxcmsuer。DMP日志文件=jxcmsuer.log闪回_scn=21750361864并行=4
导出版本12 .1 .0 .2 .0-2018年四月13日在Fri生产16360 .666666666616
版权所有(c) 1982年、2014年，甲骨文和/或其附属公司。保留所有权利。
连接到：甲骨文数据库12c企业版12.1.0.2.0版-64位生产
借助分区、真实应用集群、自动存储管理，OLAP，
高级分析和真实应用测试选项
自动启用闪回以保持数据库完整性。
正在启动"系统"。SYS _ EXport _ SCHEMA _ 03 ' :系统/* * * * * * *目录=cis _ dir schemas=jxcmsuer转储文件=jxcmsuer。DMP日志文件。原木闪回_scn=21750361864并行=4
使用阻碍方法进行评估.
正在处理对象类型模式导出/表格/表格数据
使用区块法的总估算： 132兆字节
正在处理对象类型模式_导出/用户
正在处理对象类型模式_导出/系统_授权
正在处理对象类型SCHEMA_EXPORT/ROLE_GRANT
正在处理对象类型SCHEMA_EXPORT/DEFAULT_ROLE
正在处理对象类型SCHEMA _ EXPORT/TABLOGY _ QUOTA
正在处理对象类型SCHEMA _ EXport/PRE _ SCHEMA/PROCACT _ SCHEMA
正在处理对象类型SCHEMA _ EXport/SEQUEST/SEQUEST
正在处理对象类型模式_导出/序列/授权/所有者_授权/对象_授权
正在处理对象类型模式_导出/表格/表格
正在处理对象类型SCHEMA _ EXPORT/TABLE/GRANT/OWNER _ GRANT/OBJECT _ GRANT
正在处理对象类型模式_导出/表格/注释
正在处理对象类型模式_导出/函数/函数
正在处理对象类型SCHEMA _ EXport/PRocESS/PRocESS
正在处理对象类型模式导出/函数/改变函数
正在处理对象类型SCHEMA _ EXport/PRocESS/ALTER _ PRocESS
正在处理对象类型模式_导出/视图/视图
正在处理对象类型SCHEMA _ EXport/TABLE/INDEX/INDEX
正在处理对象类型SCHEMA _ EXport/TABLE/CONSTRAINT/CONSTRAINT
正在处理对象类型SCHEMA _ EXport/TABLE/INDEX/STATISTICS/INDEX _ ST
ATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
Processing object type SCHEMA_EXPORT/JOB
. . exported "JXCMSUER"."JXC_PLAN_REPAYMENT" 48.08 MB 664579 rows
ORA-31693: Table data object "JXCMSUER"."JXC_PLAN_REPAYMENT_180307" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/data/back/exp_dir/jxcmsuer.dmp" for write
ORA-19505: failed to identify file "/data/back/exp_dir/jxcmsuer.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "JXCMSUER"."JXC_PLAN_REPAYMENT_0301" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/data/back/exp_dir/jxcmsuer.dmp" for write
ORA-19505: failed to identify file "/data/back/exp_dir/jxcmsuer.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
. . exported "JXCMSUER"."JXC_INVESTMENT_MATCHING" 5.604 MB 34343 rows
. . exported "JXCMSUER"."JXC_U_CREDITORS_RIGHTS_180307" 3.104 MB 3619 rows
. . exported "JXCMSUER"."JXC_HS_AUTO_DEBT_ASSIGNMENT" 1.579 MB 20690 rows
. . exported "JXCMSUER"."JXC_BID_INFO" 1.198 MB 7414 rows
ORA-31693: Table data object "JXCMSUER"."JXC_U_CREDITORS_RIGHTS" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout
ORA-31617: unable to open dump file "/data/back/exp_dir/jxcmsuer.dmp" for write
ORA-19505: failed to identify file "/data/back/exp_dir/jxcmsuer.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
修改数据库参数aq_tm_processes
[oracle@jxrac1 exp_dir]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 13 16:22:00 2018
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
SQL> show parameter aq_tm_processes;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 2
SQL> alter system set aq_tm_processes=1 scope=memory;
System altered.
SQL> show parameter aq_tm_processes;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 1
重新导出数据，报错消失，导出正常。
关于“expdp导出数据时候出现报错怎么办”这篇文章就分享到这里了，希望
内容来源网络，如有侵权，联系删除，本文地址：https://www.230890.com/zhan/107942.html