Expdp encountered ORA-31693 & ORA-00922, expdpora-31693

Expdp when encountering ORA-31693 & ORA-00922, expdpora-31693
Expdp ORA-31693 & ORA-00922
The following error is reported when executing 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
The expdp command is:
Nohup expdp HQ_X1/HQ_X1 DUMPFILE = HQ_X1 % u. dmp directory = DIR1 parallel = 8 flashback_scn = 10838324803 &
An official document provides an explanation:
A Datapump Export fails:
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:
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 causes an error. If you want to avoid an error, disable parallel, or apply a patch, you can apply the patch online:
<Instance_shutdown> false </instance_shutdown>
<Instance_shutdown_message> </instance_shutdown_message>
<Online_rac_installable> true </online_rac_installable>
This patch only updates a pld file and updates a package. It takes a free time for the system. 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 Intermediate Patch installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle main directory:/u01/app/oracle/product/11.2.0/db_1
Main product list:/u01/app/oraInventory
From:/etc/oraInst. loc
OPatch version: 11.1.0.6.6
OUI version: 11.2.0.1.0
OUI location:/u01/app/oracle/product/11.2.0/db_1/oui
Log File Location:/u01/app/oracle/product/11.2.0/db_1/export toollogs/opatch/opatch2015-06-23_22-55-59 pm. log
Patch history file:/u01/app/oracle/product/11.2.0/db_1/export toollogs/opatch/opatch_history.txt
ApplySession applies the Intermediate Patch '200' to OH '/u01/app/oracle/product/11.2.0/db_1'
Running prerequisite checks...
OPatch detects the non-cluster Oracle main directory from the product list and patches the local system only.
Back up the file and product list for the Oracle main directory (not for automatic rollback)
Backing up files affected by patch '123' for restoration. This operation takes some time...
Backing up files affected by patch '123' for rollback. This operation takes some time...
Installing patches for oracle. rdbms and 11.2.0.1.0...
Copy the file to "/u01/app/oracle/product/11.2.0/db_1/rdbms/admin/prvtbpw. plb"
Installing patches for oracle. rdbms. dbscripts and 11.2.0.1.0...
Copy the file to "/u01/app/oracle/product/11.2.0/db_1/rdbms/admin/prvtbpw. plb"
ApplySession adds the Intermediate Patch '123' to the product list
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 @ dB host 9243068] $
After applying the patch, run prvtbpw. plb as sysdba.
If the problem expdp is expdp again, no error is reported and the problem is resolved.