Hi All,

I facing a problem in setting up a dblink

1. I have created a dblink from one 8.1.7 db to another
2. Both the DB's reside in the same machine
3. I am able to query a table like''

select * from [Email Address Removed] but when i do a insert fails

insert into [Email Address Removed] select b.col1, b.col2, b.col3 from A_view

It fails with a message

ORA-02019 - Connection discription for remote database not found
ORA-02063- Preceding line from <dblink>

Here A_view is a view. If I create a table with the same structure that
of the view and insert , I am able to insert. I am unable to get any
clues.Have any one of you faced this problem??

I have set GLOBAL_NAMES as True , I tried with False also , Tnsname in
the server is defined correctly, Distributed_transactions = 10

Both the Instances are 8.1.7.0.0 running in Solaris 5.8

Pls help me

Cheers

Sriram Kumar




Oracle LazyDBA home page