Home » RDBMS Server » Server Utilities » Database Import failed (Error Code:IMP-00098)
Database Import failed (Error Code:IMP-00098) [message #294999] Mon, 21 January 2008 02:20 Go to next message
dba_giri
Messages: 26
Registered: July 2007
Location: Hyderabad
Junior Member
Hi..,
while importing using the following
imp command am getting the following error, can u please let me know the problem might be what

C:\>imp system/mgr123@db123 file=c:\1\atc_prod_1.dmp,c:\1\atc_prod_2.dmp,c:\1\atc_3.dmp filesize=2000m log=c:\1\atc_prod fromuser=atc_uat touser=atc_dev

imp system/virmgr@arbdb file=c:\1\stc_prod_02-12-2007_1.dmp,c:\1\stc_prod_02-12-2007_2.dmp,c:\1\stc_02-12-2007_3.dmp filesize=200 log=c:\1\stc_prod fromuser=stc_uat touser=stc_80119

Error:
***********
illegal lob length marker 64738
bytesread = 01776219136
TABLE =
IMP-00098: INTERNAL ERROR: impgst2

So, please do the needful.

Thanks in Advance
Giri K.Y.
Re: Database Import failed (Error Code:IMP-00098) [message #295000 is a reply to message #294999] Mon, 21 January 2008 02:24 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
IMP-00098: INTERNAL ERROR: %s
 *Cause:  An INTERNAL error occurred.
 *Action: Contact Oracle Worldwide Support.

Verify dump file has been transfered in binary mode.
Verify file size actual and given in imp command (I have some doubts on "filesize=200").

Please post in the correct forum.

Regards
Michel

Previous Topic: How to use two functions for a column in control file
Next Topic: Using a condition in SQL Loader for comma delimited file
Goto Forum:
  


Current Time: Tue Dec 24 23:22:49 CST 2024