The text after the IMP-00041 is necessary to debug the issue of improperly compiled objects.
Chances are these are the db views for some join forms that were not properly compiled properly before the export (common for join forms) on the last db; or db views for view forms that reference a db link. For the ORA-12154, chances are you have a view form that uses a db link that does not exist on the oracle instance to which you are importing the dump. If this is the case, correct this by creating the db links before running the import. Axton Grams On 9/14/06, McKenzie, James J C-E LCMC HQISEC/L3 <[EMAIL PROTECTED]> wrote:
** Dmitry: Are you attempting to import to an existing database or a brand new one? James McKenzie -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bezhenar, Dmitry Sent: Thursday, September 14, 2006 9:15 AM To: [email protected] Subject: OT: Oracle question Hello List, I am a newbie in Oracle and I have some problems with importing a full database dump. During the import process I receive the following errors - IMP-00041: Warning: object created with compilation warnings (many times) IMP-00017: following statement failed with ORACLE error 12154: .... IMP-00003: ORACLE error 12154 encountered ORA-12154: TNS:could not resolve service name (twice) Thank you. PS: The import command is the following Imp system/*** file=*** full=y log=*** Kind Regards Dmitry Bezhenar _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125_______________________This posting was submitted with HTML in it___
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
