Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
Oracle Database + Options
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Nov 8, 2012 3:11 AM by
Error when i create a subconsult with dblink between 3 instances.
Nov 7, 2012 11:01 AM
I have 3 instances and i want to work between then. The error ocurrs when i use subquery, This is the code:
update erie.rie_cbtrega@l$e_tfcries rgr
set rgr.c_descri = ( select rg.c_descri
from dadm.cbtrega@l$e_tfccie rg
where rg.c_idrega = rgr.c_idrega
When i execute upadte without subquery "( select rg.c_descri from dadm.cbtrega@l$e_tfccie rg where rg.c_idrega = rgr.c_idrega)" the result is successfully, but when i add subquery the result is
ORA-02019: no se ha encontrado la descripción de la conexión para la base de datos remota
ORA-02063: line precediendo a TFCCIE
ORA-02063: 2 lines precediendo a L$E_TFCRIES
This content has been marked as final.
Show 1 reply
Re: Error when i create a subconsult with dblink between 3 instances.
Nov 8, 2012 3:11 AM
in response to
you have chosen the wrong forum, because your problem has nothing to do with Advanced Queueing.
You have to check, if the DB link "l$e_tfccie" does exist and you have the rights to access it
(it would be helpful if you could paste english error messages instead of spanish ones).