| IMPORT ERROR !!! HELP ME URGENT [message #368024] |
Mon, 11 October 1999 07:53  |
Rajesh Matkar
Messages: 5
Registered: October 1999
|
Junior Member |
|
|
Hi,
When I am Import file from Oracle8 Server on NT,I got "ORA-03113 End-of-file on communication Channel" and IMP-00021 Operating System error - error code (dec 2,hex 0x2) and finally IMP-0000 Import terminated unsucessfully" messageses. I also gone through Error-Message manual but still confusion.
I am appricaited if some one give me error reason.
I need help very badly.
Thanx
Rajesh Matkar
rmatkar@hotmail.com
|
|
|
|
| Re: IMPORT ERROR !!! HELP ME URGENT [message #368049 is a reply to message #368024] |
Fri, 19 November 1999 17:21  |
sharan alva
Messages: 57
Registered: November 1999
|
Member |
|
|
you are getting the following errors i.e. imp-00003, ora-3113, imp-000021 and imp-00000. Th e reason being "TNSNAMES.ORA" is missing the alias for the database link. The statement that was failing was accessing a remote table via a "db_link" AND THE "TNSNAMES.ORA" file did not have teh entry for the "db_link" alias.
You need to add teh alias to the "TNSNAMES.ORA" file and rerun the import job to completion
Sharan
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
