| impdp error in Oracle 10g [message #461099] |
Wed, 16 June 2010 09:53  |
oracle149
Messages: 1
Registered: June 2010
|
Junior Member |
|
|
While importing a 22 GB dump file ,exported from producation db without any errors, into a local server,I am getting the following errors as per the log:
opyright (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 is really appreciable as taking an export again is not an option for me.....
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
