用PL/SQL中SQL语句实现用DBLINK完成数据的抽取

drop public database link TLINK1;--删除原来定义的data base link

create public database link TLINK1 connect to SYSTEM identified by "xxxx" USING '10.10.112.123:1521/orcl';  --创建新的data base link

create table fact_product_sale as
select * from  fact_product_sale@TLINK1;--创建查询出来的表