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备份数据库的使用说明
oracle备份还原（expdp/impdp）
impdp ora-39002,ora-39166,ora-39164的问题及解决
本文永久更新链接地址：