Hi I created a Database link from user test to fetch records from the another database with the same user test.
Database link was successful. The problem is, when I am trying to use it , it is giving the error
Select * from test@prod1;
ORA-12514 : Message 12514 not found; product=RDBMS; facility=ORA
Can any one suggest me where I am doing wrong
[Edited by Kishore on 05-09-2001 at 02:55 PM]
You have to create the link so:
create database link el_sur
connect to usuario identified by clave
usuario is the user;
clave is the password
el_sur is the link's name.
Then in $ORACLE_HOME/network/admin/tnsnames.ora
(ADDRESS = (PROTOCOL= TCP)(Host= enel02)(Port= 1521))
(CONNECT_DATA = (SID = conv))
enel02 is the name of the remote machine, conv is de database name.
Now you can do it:
select * from your_table@el_sur;
Thanks, it is working. Infact my 2 databases are having the same GLOBAL NAME and is the problem I faced. When I chaged it back, every thing is fine.