-
impdp error in Oracle 10g
While trying to import a 22 GB dumpfile exported from production without any errors, I have received the following error while import of the file on a local machine:The log is mentioned below:
Import: Release 10.2.0.1.0 - Production on Wednesday, 16 June, 2010 9:12:05
Copyright (c) 2003, 2005, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Master table "ERRE"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "ERRE"."SYS_IMPORT_FULL_01": 'ERRE/********@ecprod' full=y remap_schema=ERRE:ERRE,essc:essc,EPPA:EPPA directory=dba_dir dumpfile=dump01.dmp LOGFILE=LOG01.LOG
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"essc" already exists
ORA-31684: Object type USER:"ERRE" already exists
ORA-31684: Object type USER:"EPPA" 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/SYNONYM/SYNONYM
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "ERRE"."ER_PATFORMS" 19.34 GB 48582 rows
. . imported "ERRE"."ER_FORMAUDITCOL" 341.6 MB 3406926 rows
. . imported "ERRE"."ER_USERSESSIONLOG" 191.1 MB 636744 rows
. . imported "ERRE"."ER_FORMLIBVER" 184.2 MB 292 rows
ORA-31693: Table data object "ERRE"."ER_FORMLIB" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-00600: internal error code, arguments: [klxpr_03], [1], [], [], [], [], [], []
ORA-31693: Table data object "ERRE"."ER_FORMSLINEAR" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-02368: file is not valid for this load operation
ORA-31693: Table data object "ERRE"."AUDIT_INSERT" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-02368: file is not valid for this load operation
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31672: Worker process DW01 died unexpectedly.
Job "ERRE"."SYS_IMPORT_FULL_01" stopped due to fatal error at 11:40:07
ORA-39014: One or more workers have prematurely exited.
Any help would be really appreciable as taking export again from prod Db is not an option for me!!!
-
call oracle support, or use the ora-600 lookup tool on the support site
-
Check Note 741861.1 in metalink. You might be hitting bug 6900300 which Oracle development are still developing a fix for.
As davey pointed out, you better log a SR with Oracle support, that's what you should do for any ORA-00600 or ORA-07445.
Regards,
Hany.
Anyone can hold the helm when the sea is calm.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|