How to insert data from one table to another from two oracle database servers with public database link? -


i going insert data table2 table1 , 2 tables in different database, different servers.

there public database links both database. in details of public database links, there names of owner, db_link, username , host.

i want ask how use public database links insert data table2 table1, thanks.

i have tried like

insert table1 select 'xxxx, xxxx, xxxx', columns_from_table2 table2@"db_link" criteria; 

but prompts out error message of

ora-02019: connection description remote database not found 02019. 00000 -  "connection description remote database not found" 

i think not using correct dblink. try , tell me:

select * dual@"db_link"

select * dba_db_links db_link = "[your_db_link_name]"


Comments

Popular posts from this blog

c# - Better 64-bit byte array hash -

webrtc - Which ICE candidate am I using and why? -

php - Zend Framework / Skeleton-Application / Composer install issue -