OraFAQ Forum: Server Utilities » Import Dump file (merged 2)

Home » RDBMS Server » Server Utilities » Import Dump file (merged 2) (11g R2, Windows 7 32 bit)

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

Import Dump file (merged 2) [message #544841]

Fri, 24 February 2012 04:16

glmjoy
Messages: 187
Registered: September 2011
Location: KR

Senior Member

Hi,
I am facing a problem importing DMP file in 11g. While importing it gives me error not responding. Sorry guys I have to attached the jpg file for that to clear you my point whats wrong is going during import. My Dump is on 9i i want to import that on 11G R2.

Thanks in Advance

Attachment: impport.JPG
(Size: 64.12KB, Downloaded 1905 times)

Report message to a moderator

Re: Import Dump file (merged 2) [message #544849 is a reply to message #544841]

Fri, 24 February 2012 04:43

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

Senior Member
Account Moderator

Many of us can't or don't want to download files, so post them inline in text mode and post them formatted.

So, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Use the "Preview Message" button to verify.

Regards
Michel

Report message to a moderator

Re: Import Dump file (merged 2) [message #544863 is a reply to message #544849]

Fri, 24 February 2012 06:02

glmjoy
Messages: 187
Registered: September 2011
Location: KR

Senior Member

Hi,
I am facing a problem importing DMP file in 11g R2 from 9i R2. While importing it gives me error not responding. The error I got is c:\ imp system/password full=y file=adv.dmp fromuser=adv to user=ADV ignore=Y

"IMP-00015 following statement failed because the object already exist"

"CREATE TYPE "ADDRESS_TRY" TIMESTAMP '2009-10-02:01:28:11' OID'87E7C689'
"41CBBD0536F51407D114'
" as object"
"<street varchar2<30>,
"city varachr2<20> ,"
"zip number <7>>"
illegal lob length marker 49664
byteread=0000000000000
TABLE=IMP-00098 Internal Error: impgst2

Report message to a moderator

Re: Import Dump file (merged 2) [message #544871 is a reply to message #544863]

Fri, 24 February 2012 06:18

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

Senior Member
Account Moderator

Post the complete log.
However:

IMP-00098: INTERNAL ERROR: %s
 *Cause:  An INTERNAL error occurred.
 *Action: Contact Oracle Worldwide Support.

Regards
Michel

Report message to a moderator

Re: Import Dump file (merged 2) [message #545449 is a reply to message #544863]

Wed, 29 February 2012 09:11

LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL

Senior Member

Perhaps you have a space too many:

c:\ imp system/...adv.dmp fromuser=adv to user=ADV ignore=Y
+---------------- Here? -----------------^

[Updated on: Wed, 29 February 2012 09:12]

Report message to a moderator

Previous Topic:	database import problem
Next Topic:	ORACLE import error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 02 20:00:27 CST 2026