Home » SQL & PL/SQL » SQL & PL/SQL » Problem: ORA-00980: synonym translation is no longer valid
Problem: ORA-00980: synonym translation is no longer valid [message #225837] Wed, 21 March 2007 13:02 Go to next message
Jaime Stuardo
Messages: 57
Registered: March 2004
Member
Hello !!

I need to create a link from Oracle 9i to Oracle 7.3.4. In order to do that, I have used an intermediate server running Oracle 8. I have created links to some Oracle 7.3.4 tables on that Oracle 8 server.

In the Oracle 9i server I have created table synonyms that use that configured DBLink.

The problem is that when I run, for example, this query:

SELECT P.IDEPOL,
P.NUMPOL,
P.CODFORMPAGO,
P.FECINIVIG,
P.FECFINVIG,
P.FECPRIVIG,
P.CODMONEDA,
P.STSPOL,
P.CODCOBROPRIMA,
P.TIPOPOLIZA,
C.NUMID,
C.DVID,
T.NOMTER,
T.APETER
FROM ACSEL.S_TERCERO@CENTOS T, ACSEL.S_CLIENTE@CENTOS C, ACSEL.S_DATOS_PART_POLCOL@CENTOS P
WHERE T.TIPOID = C.TIPOID AND
T.NUMID = C.NUMID AND
T.DVID = C.DVID AND
C.CODCLI = P.CODCLI;

where @CENTOS is the DBlink from Oracle 9i to Oracle 8 and ACSEL.S_* are the synonyms present both in the Oracle 9i and Oracle 8 servers (but in the latter, are poiting to Oracle 7.3.4 server).

That query works perfectly, but when I add that query into a package, the error ORA-00980 occurs.

The package is under a different schema than the synonyms, but I tried to create in ACSEL schema but the same happens.

Any help will be greatly appreciated,

Jaime
Re: Problem: ORA-00980: synonym translation is no longer valid [message #225841 is a reply to message #225837] Wed, 21 March 2007 13:15 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
privs acquired via ROLE do NOT apply within PL/SQL procedures
Re: Problem: ORA-00980: synonym translation is no longer valid [message #225842 is a reply to message #225841] Wed, 21 March 2007 13:19 Go to previous messageGo to next message
Jaime Stuardo
Messages: 57
Registered: March 2004
Member
So, is there a way to achieve what I'm trying to do? maybe by doing a trick or something.

Thanks
Jaime
Re: Problem: ORA-00980: synonym translation is no longer valid [message #225844 is a reply to message #225842] Wed, 21 March 2007 13:25 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
There's a bug associated with remote synonyms used in this fashion. You can try the workarounds by:

* set global_name=true

OR

* Don't use the synonym and use the real name.

Try these "tricks" to see if they help.
Re: Problem: ORA-00980: synonym translation is no longer valid [message #225847 is a reply to message #225837] Wed, 21 March 2007 13:31 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Related info...

See "signature checking" http://download-east.oracle.com/docs/cd/A58617_01/server.804/a58227/ch16.htm

Also - you can try an alternative of creating a view as an alternative to the synonym.

create or replace view emp as select * from emp@db_link;
rather than
create or replace synonym emp for emap@db_link;


[Updated on: Wed, 21 March 2007 13:32]

Report message to a moderator

Re: Problem: ORA-00980: synonym translation is no longer valid [message #241197 is a reply to message #225847] Mon, 28 May 2007 14:58 Go to previous messageGo to next message
Jaime Stuardo
Messages: 57
Registered: March 2004
Member
Hello again,

I have created views instead of synonyms.

At Oracle 8 database I created this view (LINK_PLUTON is the db link to an Oracle 7 database):

CREATE VIEW VI_PLUTON_DATOS_PLANGPO_POLCOL
AS
SELECT *
FROM DATOS_PLANGPO_POLCOL@LINK_PLUTON


At Oracle 9 database I tried to create this other view (LINK_SONDA is the db link to the Oracle 8 database):

CREATE VIEW VI_P_DATOS_PLANGPO_POLCOL
AS
SELECT *
FROM VI_PLUTON_DATOS_PLANGPO_POLCOL@LINK_SONDA


When I run this command I get the error:

15:57:54 Error: ORA-00600: internal error code, arguments: [qctstc2o1], [1], [0], [31], [1], [3], [3], []

Any other help?
Thanks

Jaime
Re: Problem: ORA-00980: synonym translation is no longer valid [message #241270 is a reply to message #241197] Tue, 29 May 2007 01:16 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-00600 means Oracle bug.
Check on Metalink or call to Oracle support.

Regards
Michel
Previous Topic: Getting Unique Records from the table
Next Topic: Get ddl from Oracle8
Goto Forum:
  


Current Time: Sat Dec 03 16:08:07 CST 2016

Total time taken to generate the page: 0.05605 seconds