Expdp encountered ORA-31693 & amp; ORA-00922

Source: Internet
Author: User

Expdp ORA-31693 & ORA-00922

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.

Oracle Import and Export expdp IMPDP details

Solution to Oracle 10g expdp export error ORA-4031

Oracle 10gr2 rac expdp error UDE-00008 ORA-31626

Use of expdp/impdp to back up databases in Oracle

Oracle backup recovery (expdp/impdp)

Problems and Solutions of impdp ORA-39002, ORA-39166 and ORA-39164

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.