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
Messages: 26
Registered: July 2007
Location: Hyderabad
Junior Member
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

illegal lob length marker 64738
bytesread = 01776219136
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: 65088
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
 *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.


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: Wed Jul 26 00:06:19 CDT 2017

Total time taken to generate the page: 0.07005 seconds