Thank you Axton and James, I will try your suggestions tomorrow, now it's a late evening in Russia. :)
Kind Regards / C ????????? Dmitry Bezhenar -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Thursday, September 14, 2006 9:15 PM To: arslist@ARSLIST.ORG Subject: Re: Oracle question 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: arslist@ARSLIST.ORG > 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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
