Home » RDBMS Server » Backup & Recovery » datapump error on import (oracle 11 and 10)
datapump error on import [message #524877] Tue, 27 September 2011 04:46 Go to next message
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
Re: datapump error on import [message #524890 is a reply to message #524877] Tue, 27 September 2011 05:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68045
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: datapump error on import [message #524904 is a reply to message #524890] Tue, 27 September 2011 05:52 Go to previous message
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.
Previous Topic: Pre-requisites to perform RMAN BACKUP
Next Topic: can a control file backed up be present in multiple backup pieces?
Goto Forum:
  


Current Time: Fri Dec 03 12:28:53 CST 2021