1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

[Oracle] datapump import error

Discussion in 'Security, Backup and Recovery' started by bullwey, Sep 27, 2011.

  1. bullwey

    bullwey Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Hi,
    I have 2 Oracle server. One with Suse Linux (Oracle 10.2.0.4.0) and one with Windows 2003 Server x64 (Oracle 11.2.0.1.0).
    I made a mistake by installing Oracle 11 x32 on a x64 server. Nevertheless it works for about half a year. Then my backups
    with datapump don't work. I changed the SGA_TARGET down to 1024M and the datapump works again. Now I want to renew the
    Windows server and want to import the datapump schemes to the Linux server.
    Exp: expdp SCHEMA1/****@db1 DIRECTORY=dmpdir DUMPFILE=SCHEMA1_EXPDAT.DMP LOGFILE=SCHEMA1_EXP.LOG VERSION=10.2.0.3 REUSE_DUMPFILES=YES
    Imp: impdp SCHEMA1/**** DIRECTORY=dmpdir DUMPFILE=SCHEMA1_EXPDAT.DMP LOGFILE=SCHEMA1_IMP.LOG

    Log:
    ..importing SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
    ..importing SCHEMA_EXPORT/SEQUENCE/SEQUENCE
    ..importing SCHEMA_EXPORT/TABLE/TABLE
    ..importing SCHEMA_EXPORT/TABLE/TABLE_DATA
    ..importing SCHEMA_EXPORT/TABLE/INDEX/INDEX
    ORA-39083: Object type index failed to create with error:
    ORA-25126: Invalid name specified for BUFFER_POOL
    Wrong SQL:
    CREATE UNIQUE INDEX "SCHEMA1"."PK_ARTICLE" ON "SCHEMA1"."ARTICLE" ("ARTICLE_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL ) TABLESPACE "SCHEMA1" PARALLEL 1
    ORA-39083: Object type index failed to create with error:
    ORA-25126: Invalid name specified for BUFFER_POOL
    Wrong SQL:
    CREATE INDEX "SCHEMA1"."IX_ART_EANID" ON "SCHEMA1"."ARTICLE" ("EAN_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL ) TABLESPACE "SCHEMA1" PARALLEL 1
    ORA-39083: Object type index failed to create with error:
    ORA-25126: Invalid name specified for BUFFER_POOL

    V$BUFFER_POOL
    Import-DB
    ID NAME BLOCK_SIZE RESIZE_STATE CURRENT_SIZE BUFFERS TARGET_SIZE TARGET_BUFFERS PREV_SIZE PREV_BUFFERS LO_BNUM HI_BNUM LO_SETID HI_SETID SET_COUNT
    ---------------------- -------------------- ---------------------- ------------ ---------------------- ---------------------- ---------------------- ---------------------- ---------------------- ---------------------- ---------------------- ---------------------- ---------------------- ---------------------- ----------------------
    3 DEFAULT 8192 STATIC 16208 2004727 16208 2004727 16224 2006706 0 0 9 12 4

    Export-DB
    ID NAME BLOCK_SIZE RESIZE_STATE CURRENT_SIZE BUFFERS TARGET_SIZE TARGET_BUFFERS PREV_SIZE PREV_BUFFERS LO_BNUM HI_BNUM LO_SETID HI_SETID SET_COUNT
    ---------------------- -------------------- ---------------------- ------------ ---------------------- ---------------------- ---------------------- ---------------------- ---------------------- ---------------------- ---------------------- ---------------------- ---------------------- ---------------------- ----------------------
    3 DEFAULT 8192 STATIC 376 46765 376 46765 0 0 0 0 9 12 4


    Does anyone an idea?

    Regards
    Steffen
     
  2. bullwey

    bullwey Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    I found the problem --> Bug 9160088 - 11.2 EXPDP to lower version errors on import (ORA-25126)
    Thx for your help.