| IMP00017 error while importing a user dmp [message #73403] |
Fri, 16 April 2004 22:10  |
VivekR
Messages: 1
Registered: April 2004
|
Junior Member |
|
|
Hi,
I had exported a user through export utility from my DB(Oracle 9i), dropped it and then recreated it. When i try to reimport the dmp file through import utility, it imports the tables but when importing the other objects it gives the following error.
IMP-00017: FOLLOWING STATEMENT FAILED WITH ORACLE ERROR 3113:
CREATE PROCEDURE ADT_DISABLE_AUDIT_TRIGGERS
AS
----
----
END;
IMP-00003: ORACLE ERROR 3113 ENCOUNTERED
ORA-03113: END-OF-FILE ON COMMUNICATION CHANNEL
IMP-00000: IMPORT TERMINATED UNCUSCCESSFULLY
Can anyone plz suggest a solution to this. Matter most urgent. Thanks in advance
|
|
|
|
| Re: IMP00017 error while importing a user dmp [message #73407 is a reply to message #73403] |
Sat, 17 April 2004 06:48  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
Hi,
ORA-03113 indicates that the client cannot
communicate with the Oracle shadow process. Look at
your database's ALERT.LOG file for additional error
messages. If you cannot find any, scan you BDUMP and
UDUMP directories for new trace/core files. Also, see
Metalink Note 17613.1 for additional instructions.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
