| IMP-00017 Error [message #222870] |
Tue, 06 March 2007 15:34  |
munira13
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:
"CREATE FUNCTION F_GET"
...........
"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  |
 |
BlackSwan
Messages: 26766
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
