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.

  • March 3, 2017 | 23 views
  • Comments