Insert Statement

[syncdba]

Hi,
I'm trying to INSERT name(column values) into cust_type from tpt_cust_type table which is in other DB.(Username MN2
Connect:uti).
Table cust_type has only one col.

insert into cust_type
select name from tpt_cust_type.mn2@uti

Getting error:
ORA-02019: connection description for remote database not found..
Any Help

 

[LKBrwnDBA]

Did you create a database link?


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[syncdba]

That's what I was trying to do in SELECT statement.

select name from tpt_cust_type.mn2/mn2@uti.
I'm not sure its the correct syntex..

 

[syncdba]

insert into lov_customer_type(customer_type)
select name from tp2.usabad.tpt_customer_type;

I have updated my INSERT statement, Now its giving the error
"SQL command not properly ended".
Any help.

 

[LKBrwnDBA]

First you must create the database link:

CREATE DATABASE LINK uti
  CONNECT TO MyUser IDENTIFIED BY ThePassword
    USING TheServiceName;

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb