Create a copy of different Oracle database tables

1. View/table/between different networks involved/

2. In fact, some projects should not establish multiple database links.

 

Select * From tab_sbzt @ dblink_fssj

Create Table Scott. lc_sbzt as select * From tab_sbzt @ dblink_fssj;

Select * From lc_sbzt;

Create Table Scott. lc_lsxxcx as select * From tab_lsxxcx @ dblink_fssj where rownum <460;

Select * From lc_lsxxcx;

Create Table Scott. jj_sbzt as select * from atm ssd. tab_sbzt @ dblink_jj

Create Table Scott. jj_sbzt as select * From lc_sbzt

Truncate table jj_sbzt

Select * From jj_sbzt

Insert into jj_sbzt select * from atm ssd. tab_sbzt @ dblink_jj

Select * from atm ssd. tab_ssxxcx @ dblink_jj where rownum <500

Create Table Scott. jj_ssxxcx as select * From lc_lsxxcx

Truncate table jj_ssxxcx

Insert into jj_ssxxcx (select * from atm ssd. tab_ssxxcx @ dblink_jj where rownum <500)

Select * From jj_ssxxcx