Home » RDBMS Server » Server Utilities » Import Dump file (merged 2) (11g R2, Windows 7 32 bit)
Import Dump file (merged 2) [message #544841] Fri, 24 February 2012 04:16 Go to next message
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 1351 times)
Re: Import Dump file (merged 2) [message #544849 is a reply to message #544841] Fri, 24 February 2012 04:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Import Dump file (merged 2) [message #544863 is a reply to message #544849] Fri, 24 February 2012 06:02 Go to previous messageGo to next message
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
Re: Import Dump file (merged 2) [message #544871 is a reply to message #544863] Fri, 24 February 2012 06:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Import Dump file (merged 2) [message #545449 is a reply to message #544863] Wed, 29 February 2012 09:11 Go to previous message
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? -----------------^

Razz

[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:
  


Current Time: Thu Mar 28 18:54:23 CDT 2024