Re: SOS - URGENT********DB LINK

  • From: crcbedoy@xxxxxxxxxxxxxxxxx
  • To: crcbedoy@xxxxxxxxxxxxxxxxx
  • Date: Mon, 11 Sep 2006 17:49:17 -0400

insert into SRHCXN1.empleado 
select * from userid.empleado@xxxxxxxxxxxxxxxxxxxxx where 
emp_fecha_ingreso>=to_date('20060901','yyyymmdd') 
/ 



Isabel Bedoya Gómez
Centro de Gestión y Control
Tel. 2307500 ext:



crcbedoy@xxxxxxxxxxxxxxxxx 
Enviado por: oracle-l-bounce@xxxxxxxxxxxxx
11/09/2006 16:46
Por favor, responda a
crcbedoy@xxxxxxxxxxxxxxxxx


Para
<oracle-l@xxxxxxxxxxxxx>
cc

Asunto
SOS - URGENT********DB LINK







Could you please help me?? 


I am tryieng to create a DB link such as: 

CREATE DATABASE LINK PRUEBAS.US.ORACLE.COM 
CONNECT TO userid IDENTIFIED BY password 
USING 'PRUEBAS.US.ORACLE.COM'; 


And then, when I try to do: 

insert into SRHCXN1.empleado 
select * from userid.empleado@PRUEBAS where 
emp_fecha_ingreso>=to_date('20060901','yyyymmdd') 
/ 

I get the following error: 

select * from srhcxn2.empleado@PRUEBAS where 
emp_fecha_ingreso>=to_date('20060901','yyyymmdd') 
                               * 
ERROR at line 2: 
ORA-12154: TNS:could not resolve service name 


I checkl the TNSNAMES.ORA and everything is alright, could anybody please 
help me??.. I am in a rush:(.. I have the privileges as a DBA, my username 
is XXX, creating running a script to insert values to the schema SRHCXN1, 
getting the data from the userid. 

HELPPP!!!:(:( 

Isabel Bedoya Gómez
Centro de Gestión y Control
Tel. 2307500 ext:

Other related posts: