DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: impdp error in Oracle 10g

  1. #1
    Join Date
    May 2010
    Posts
    1

    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!!!

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    call oracle support, or use the ora-600 lookup tool on the support site

  3. #3
    Join Date
    Dec 2001
    Posts
    320
    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
  •  


Click Here to Expand Forum to Full Width