Home » RDBMS Server » Server Utilities » IMP-00017 Error
IMP-00017 Error [message #222870] Tue, 06 March 2007 15:34 Go to next message
Messages: 14
Registered: March 2007
Junior Member
I am getting the following error when I import a dump file into my database

IMP-00017: following statement failed with ORACLE error 3113:
"END F_GET_ ;"
IMP-00003: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
IMP-00000: Import terminated unsuccessfully

As mostly suggested by people this error occurs when connection to the database is lost....however, I do not loose connection to the database. I have tried to import the dump file a couple of times using different parameters but it always errors out at the same place during the import. Please suggest what can be done about this.

Is there a way you can read the .dmp file??

Thanks a lot in advance.
Re: IMP-00017 Error [message #222872 is a reply to message #222870] Tue, 06 March 2007 15:38 Go to previous messageGo to next message
Messages: 24958
Registered: January 2009
Location: SoCal
Senior Member
Given the lack of meaningful clues, I suspect that this is a bug.
I would not be surprised is this occurs on an "older" version of Oracle. (What is oracle version to 4 decimal places?)
I would not be surprised if this was occurring on a table with a "LOB" datatype.
DESC <TABLE_THAT_IS_FAILING> -- & post results back here

Frequently ORA-03113 produces a trace file with additional clues

[Updated on: Tue, 06 March 2007 17:32] by Moderator

Report message to a moderator

Re: IMP-00017 Error [message #222916 is a reply to message #222870] Tue, 06 March 2007 23:35 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

ORA-03113: end-of-file on communication channel

Also post your alert<sid>.log file for more information.

Previous Topic: field in datafile exceeds maximum length
Next Topic: imp / exp problem with sequence no
Goto Forum:

Current Time: Sun Oct 23 01:51:23 CDT 2016

Total time taken to generate the page: 0.13872 seconds