RE: SOS - URGENT********DB LINK
- From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
- To: "'crcbedoy@xxxxxxxxxxxxxxxxx'" <crcbedoy@xxxxxxxxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Mon, 11 Sep 2006 17:45:59 -0400
Did you check the TNSNAMES.ORA file on the database server where the SRHCXN1
schema resides? That is where Oracle looks to resolve the name
PRUEBAS.US.ORACLE.COM.
Paul Baumgartel
CREDIT SUISSE
Information Technology
DBA & Admin - NY, KIGA 1
11 Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel@xxxxxxxxxxxxxxxxx
www.credit-suisse.com
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of crcbedoy@xxxxxxxxxxxxxxxxx
Sent: Monday, September 11, 2006 5:46 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: 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:
==============================================================================
Please access the attached hyperlink for an important electronic communications
disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================
Other related posts:
