DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Friday, March 3, 2017

ORA-31693: Table data object "SCOTT"."EMP" failed to load/unload and is being skipped do error

Datapump on 11.2 RAC with PARALLEL > 1:

Error:

ORA-31693: Table data object "SCOTT"."ESCSTATUS" failed to load/unload and is being skipped do error:

Cause:
From 11.2, Datapump new parameter CLUSTER is introduced.

CLUSTER : Default=Y

Purpose :
Determines whether Data Pump can use Oracle Real Application Clusters (RAC)
resources and start workers on other Oracle RAC instances.

Syntax and Description : CLUSTER=[Y | N]

Solution:
To force Data Pump to use only the instance where the job is started and to replicate pre-Oracle Database 11g release 2 (11.2) behavior, specify CLUSTER=N.

Example:
$ expdp userid=SYSTEM/*****  DIRECTORY=EXPORT  DUMPFILE=expdp%U.dmp CLUSTER=N PARALLEL=3.

No comments: