RE: Compile Procedure with Synonym/Dblink Oracle 9.2

Ron,

What this means is that the object referenced by the dblink either no longer exists or you do not have access to it anymore.

You have a few options:

1). Recreate the object (or get access to it) at the location

    the dblink is pointing to.
2). Modify the procedure so that the reference goes away. 3). Create a temporary object in the local database and a private

    Database link in that account so that you can compile the procedure.

I'm not sure what #2 or #3 buys you except being able to compile the proc. The proc was obviously doing something in the remote database, so, functionally, this may not help you.

Tom

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Smith, Ron L. Sent: Friday, July 08, 2005 1:43 PM
To: Oracle-l
Subject: Compile Procedure with Synonym/Dblink Oracle 9.2

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
--

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