OraFAQ Forum: Backup & Recovery » datapump error on import

Home » RDBMS Server » Backup & Recovery » datapump error on import (oracle 11 and 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

datapump error on import [message #524877]

Tue, 27 September 2011 04:46

bullwey
Messages: 2
Registered: September 2011
Location: Germany

Junior Member

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

Report message to a moderator

Re: datapump error on import [message #524890 is a reply to message #524877]

Tue, 27 September 2011 05:27

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-25126: Invalid name specified for BUFFER_POOL
 *Cause:  The name of the buffer pool specified by the user is
          invalid. The only valid names are KEEP, RECYCLE
          and DEFAULT.
 *Action: Use a valid name or remove the BUFFER_POOL clause.

Quote:

BUFFER_POOL )

Buffer pool name is missing.

Regards
Michel

Report message to a moderator

Re: datapump error on import [message #524904 is a reply to message #524890]

Tue, 27 September 2011 05:52

bullwey
Messages: 2
Registered: September 2011
Location: Germany

Junior Member

No, buffer_pool is set on both server. But I found the problem --> Bug 9160088 - 11.2 EXPDP to lower version errors on import (ORA-25126)
Thx for your help.

Report message to a moderator

Previous Topic:	Pre-requisites to perform RMAN BACKUP
Next Topic:	can a control file backed up be present in multiple backup pieces?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 22 15:04:13 CDT 2025