I changed, and still getting errors, now I get this error: ERROR at line 2: ORA-02068: following severe error from DESAROLLO9 ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory Isabel Bedoya Gómez Centro de Gestión y Control Tel. 2307500 ext: "Smith, Steven K - MSHA" <Smith.Steven@xxxxxxx> 11/09/2006 17:02 Para <crcbedoy@xxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx> cc Asunto RE: SOS - URGENT********DB LINK That error is because you defined the database link as PRUEBAS.US.ORACLE.COM and you reference it in the statement as PRUEBAS. Be consistent. Steve Smith Envision Technology Partners / MSHA MSIS Team Desk: 303-231-5499 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of crcbedoy@xxxxxxxxxxxxxxxxx Sent: Monday, September 11, 2006 3: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: