My Oracle Support Banner

DataPump Import (IMPDP) Fails With Errors ORA-39097 ORA-39065 ORA-12801 ORA-1460 In RAC Environment (Doc ID 1427537.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.
***Checked for relevance on 08-Oct-2013***


The following errors are being reported in the import log:

Import: Release - Production on Lun. Févr. 6 10:07:26 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Master table "AGRT997"."IMPDP_MDHP1_201202006100500" successfully loaded/unloaded
Starting "AGRT997"."IMPDP_MDHP1_201202006100500": AGRT997/******** PARFILE=D:\Batch\script_gen\DP_IMP_MDHP1_pour_S1.PAR
. . imported "AGRMDHS1"."DOCMNIMAGE"          4.455 GB      65505 rows
ORA-39097: Data Pump job encountered unexpected error -12801
ORA-39065: unexpected master process exception in MAIN
ORA-12801: error signaled in parallel query server PZ99, instance QUBC1-SGBDA16N:accp2 (2)
ORA-01460: unimplemented or unreasonable conversion requested
Job "AGRT997"."IMPDP_MDHP1_201202006100500" stopped due to fatal error at 10:19:51



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.