expdp时遇到ORA-31693ORA-00922

expdp时遇到ORA-31693ORA-00922

expdp时遇到ora-31693&ora-00922
执行expdp遇到如下报错：
ora-31693: table data object "hq_x1"."b3901_p" failed to load/unload and is being skipped due to error:
ora-00922: missing or invalid option
ora-31693: table data object "hq_x1"."b3903" failed to load/unload and is being skipped due to error:
ora-00922: missing or invalid option
ora-31693: table data object "hq_x1"."b3904" failed to load/unload and is being skipped due to error:
ora-00922: missing or invalid option
ora-31693: table data object "hq_x1"."b3906" failed to load/unload and is being skipped due to error:
ora-00922: missing or invalid option
ora-31693: table data object "hq_x1"."b3905" failed to load/unload and is being skipped due to error:
ora-00922: missing or invalid option
expdp命令为：
nohup expdp hq_x1/hq_x1 dumpfile=hq_x1%u.dmp directory=dir1 parallel=8  flashback_scn=10838324803 &
官方的一篇文档给出了解释：
a datapump export fails with:
ora-31693: table data object "scpomgr"."fcst" failed to load/unload and is being skipped due to error:
ora-00922: missing or invalid option
changes
the use of the parallel command line option triggers this issue.
cause
the cause of this problem has been identified in:
bug:8734963 - ora-31693 and ora-922 occurs in expdp with parallel parameter.
closed as duplicate of:
bug:9243068 - expdp returns ora-00922: missing or invalid option when using consistent=true
the cause of the issue is an incorrect parallel value for an external table to be exported when using deferred segment creation.
bug:9243068 is fixed in rdbms 12.1.
solution
to implement a solution for bug:9243068, please execute any of the below alternative solutions:
upgrade to 12.1 in which bug:9243068 is fixed.
or
apply patchset release 11.2.0.4 in which bug:9243068 is fixed.
or
download and apply interim patch:9243068, if available for your platform and rdbms release. to check for conflicting patches, please use the mos patch planner tool. if no patch is available, file a service request through my oracle support for your specific oracle version and platform.
or
do not use the parallel command line option.
bug8734963导致了报错，，如果要避免报错，或者禁用parallel，或者打patch，先把patch下下来之后，发现这个patch可以在线apply:
false

true
该patch仅仅是更新一个pld文件，并更新了一个package.抽个系统空闲时段，apply patch:
[oracle@dbhost 9243068]$ /u01/app/oracle/product/11.2.0/db_1/opatch/opatch apply
invoking opatch 11.1.0.6.6
oracle 中间补丁程序安装程序版本 11.1.0.6.6
版权所有 (c) 2009, oracle corporation。保留所有权利。
oracle 主目录      : /u01/app/oracle/product/11.2.0/db_1
主产品清单: /u01/app/orainventory
  从          : /etc/orainst.loc
opatch 版本    : 11.1.0.6.6
oui 版本      : 11.2.0.1.0
oui 位置      : /u01/app/oracle/product/11.2.0/db_1/oui
日志文件位置 : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-06-23_22-55-59下午.log
patch history file: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt
applysession 将中间补丁程序 '9243068' 应用到 oh '/u01/app/oracle/product/11.2.0/db_1'
running prerequisite checks...
opatch 从产品清单中检测到非集群 oracle 主目录, 将仅对本地系统打补丁。
为 oracle 主目录备份文件和产品清单 (不是用于自动回退)
正在备份受补丁程序 '9243068' 影响的文件以用于还原。此操作将需要一些时间...
正在备份受补丁程序 '9243068' 影响的文件以用于回退。此操作将需要一些时间...
正在为组件 oracle.rdbms, 11.2.0.1.0 打补丁...
将文件复制到 "/u01/app/oracle/product/11.2.0/db_1/rdbms/admin/prvtbpw.plb"
正在为组件 oracle.rdbms.dbscripts, 11.2.0.1.0 打补丁...
将文件复制到 "/u01/app/oracle/product/11.2.0/db_1/rdbms/admin/prvtbpw.plb"
applysession 将中间补丁程序 '9243068' 添加到产品清单
verifying the update...
inventory check ok: patch id 9243068 is registered in oracle home inventory with proper meta-data.
files check ok: files from patch id 9243068 are present in oracle home.
opatch succeeded.
[oracle@dbhost 9243068]$
patch　apply之后，以sysdba执行了prvtbpw.plb。
再次expdp时，未再报错，问题解决。

Oracle导入导出expdp IMPDP详解

Oracle 10g expdp导出报错ORA-4031的解决方法

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626

Oracle中利用expdp/impdp备份数据库的使用说明

论小文

可靠的论文写作助手，包含11种学术写作类型，万字论文一键生成，可降重降AIGC，参考文献真实可标注，图表代码均可自定义添加。

435

查看详情

Oracle备份还原（expdp/impdp）

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 

本文永久更新链接地址：