Fast synchronization of Oracle Dblinik tables

Create Public database link Link_mm_dev
Connect to STL identified by Fosssit
Using ' (DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.10.111) (PORT = 1521))
)
(Connect_data =
(service_name = FOSSDBSB)
)
)‘;

--1 Link_mm_dev dblink Name
--2%mm% external database required tables
Declare
Num number (1);
Begin
For V_row in (select T.table_name
from [email Protected]_mm_dev t
where t.table_name like '%mm% ') loop
Select COUNT (1)
Into num
From User_tables t
where t.table_name = V_row.table_name;
If num > 0 Then
Execute immediate ' drop table ' | | V_row.table_name;
num:=0;
End If;
Execute immediate ' CREATE TABLE ' | | V_row.table_name | |
' AS SELECT * from ' | | v_row.table_name| | ' @link_mm_dev ';
End Loop;
End

Fast synchronization of Oracle Dblinik tables