IMPDP - ORA-39097 ORA-39065 ORA-00600 [15735], [2236], [2152], [] (Doc ID 1966574.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Enterprise Manager for Oracle Database - Version 10.1.0.2 to 10.2.0.5 [Release 10.1 to 10.2]
Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.5.0 [Release 10.1 to 10.2]
Oracle Database - Standard Edition - Version 10.1.0.2 to 10.2.0.5.0 [Release 10.1 to 10.2]
Oracle Database - Personal Edition - Version 10.1.0.2 to 10.2.0.5.0 [Release 10.1 to 10.2]
Information in this document applies to any platform.

Symptoms

You exported a schema TC with Export Data Pump and try to import the schema into 10.2.0.5 with Import Data Pump. The import DataPump job fails with an internal error:

$ impdp system/manager DIRECTORY=my_dir DUMPFILE=expdp_f%u.dmp LOGFILE=impdp_f.log FULL=y PARALLEL=24

Import: Release 10.2.0.5.0 - 64bit Production on Thursday, 22 January, 2015 12:27:33
Copyright (c) 2003, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01":  system/******** DIRECTORY=my_dir DUMPFILE=expdp_f%u.dmp LOGFILE=impdp_f.log FULL=y PARALLEL=24
Processing object type SCHEMA_EXPORT/USER
ORA-39097: Data Pump job encountered unexpected error -600
ORA-39065: unexpected master process exception in DISPATCH
ORA-00600: internal error code, arguments: [15735], [2236], [2152], [], [], [], [], []
ORA-31684: Object type USER:"TC" already exists
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/LIBRARY/LIBRARY
Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/TYPE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/DB_LINK
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
ORA-39097: Data Pump job encountered unexpected error -600
ORA-39065: unexpected master process exception in DISPATCH
ORA-00600: internal error code, arguments: [15735], [2236], [2152], [], [], [], [], []
Processing object type SCHEMA_EXPORT/CLUSTER/CLUSTER
Processing object type SCHEMA_EXPORT/CLUSTER/INDEX
ORA-39097: Data Pump job encountered unexpected error -600
ORA-39065: unexpected master process exception in DISPATCH
ORA-00600: internal error code, arguments: [15735], [2236], [2152], [], [], [], [], []
Processing object type SCHEMA_EXPORT/TABLE/TABLE
ORA-39097: Data Pump job encountered unexpected error -600
ORA-39065: unexpected master process exception in MAIN
ORA-00600: internal error code, arguments: [15735], [2236], [2152], [], [], [], [], []
Job "SYSTEM"."SYS_IMPORT_FULL_01" stopped due to fatal error at 12:28:06

 

Cause

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 hundreds of Community platforms