IMPDP - ORA-39097 ORA-39065 ORA-00600 [15735], [2236], [2152], []
(Doc ID 1966574.1)
Last updated on MAY 17, 2021
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]
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
NOTE: The document content below, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.
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/<PASSWORD> 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
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
Changes
NONE
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |