Oracle-L: RE: copycommit probs

From: Hatzistavrou John <John.Hatzistavrou.sema_at_mail.tellas.gr>
Date: Thu, 06 Mar 2003 01:48:55 -0800
Message-ID: <F001.00561DDE.20030306014855@fatcity.com>

Case resolved.

Hint. Copy does only use the alias in tnsnames.ora and not the loopback db_links

Kind Regards,

Hatzistavrou Yannis
Database Administrator
SchlumbergerSema
Phone ext. 478
Email: <mailto:John.Hatzistavrou.sema_at_mail.tellas.gr> John.Hatzistavrou.sema_at_mail.tellas.gr

-----Original Message-----
Sent: Thursday, March 06, 2003 10:54 AM
To: Multiple recipients of list ORACLE-L

Dear All,

I am trying to copy a local table to another local . I have created the link which is working when doing a select but when it comes to copying it gives an ORA-12154 eror.

How can I resolve this?

Kind Regards,

Hatzistavrou Yannis

Database Administrator

SchlumbergerSema

Phone ext. 478

Email: <mailto:John.Hatzistavrou.sema_at_mail.tellas.gr> John.Hatzistavrou.sema_at_mail.tellas.gr

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Hatzistavrou John
INET: John.Hatzistavrou.sema_at_mail.tellas.gr

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Mar 06 2003 - 03:48:55 CST