Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Import data - errors: IMP-00017, IMP-00003, ORA-04052, ORA-00604, ORA-12154

587510Nov 6 2007 — edited Nov 10 2007
When I try to import data from dmp file to my database I found errors whitch repeat all time..
First console show me:

IMP-00017: following statement failed with ORACLE error 4052

then show all procedure in which there are errors. After procedure I've got:

IMP-00003: ORACLE error 4052 encountered
ORA-04052: error occurred when looking up remote object THA.DB_OBJECT@SDW.SM
ORA-00604: error occurred at recursive SQL level 1
ORA-12154: TNS:could not resolve service name
IMP-00017: following statement failed with ORACLE error 4043:
"ALTER PROCEDURE "CHECK_TIMESTAMP" COMPILE TIMESTAMP '2006-09-18:14:45:"
"05'"
IMP-00003: ORACLE error 4043 encountered
ORA-04043: object CHECK_TIMESTAMP does not exist

and after that the same errors for another procedures :( What can I do??
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 8 2007
Added on Nov 6 2007
12 comments
3,749 views