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

From: <crcbedoy_at_proteccion.com.co>
Date: Mon, 11 Sep 2006 17:49:17 -0400
Message-ID: <OF3FAEDEEC.1176BA3E-ON052571E6.0077C3B8-852571E6.00771572@proteccion.com.co>

insert into SRHCXN1.empleado
select * from userid.empleado_at_PRUEBAS.US.ORACLE.COM where emp_fecha_ingreso>=to_date('20060901','yyyymmdd')
/

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

crcbedoy_at_proteccion.com.co
Enviado por: oracle-l-bounce_at_freelists.org 11/09/2006 16:46
Por favor, responda a
crcbedoy_at_proteccion.com.co

Para
<oracle-l_at_freelists.org>
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_at_PRUEBAS where emp_fecha_ingreso>=to_date('20060901','yyyymmdd')
/

I get the following error:

select * from srhcxn2.empleado_at_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:

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Sep 11 2006 - 16:49:17 CDT