Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Compile Procedure with Synonym/Dblink Oracle 9.2

Compile Procedure with Synonym/Dblink Oracle 9.2

From: Smith, Ron L. <rlsmith_at_kmg.com>
Date: Fri, 8 Jul 2005 12:43:18 -0500
Message-ID: <270A0BDDFDE54E41B78F0F06D82A66B801346B2E@okcexg3.kmg.com>


I am trying to compile a procedure that contains a synonym pointing to another database.
I am getting an error ORA-00980 Synonym translation is no longer valid.

Is there an easy way around this?

Thanks!
Ron

Important Notice!!
If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you.

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jul 08 2005 - 12:45:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US