有关Oracle数据库拉表的sql ,只限于每次拉一张表

下面是范例的SQL

拉表


drop public database link datacenter;
create public database link datacenter
connect to  XXX_用户名  identified by  XXX_密码
using'(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = XXX_数据库对于的ip地址


 


)(PORT = 1521))
(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = center))
 )';
create table XXX_需要拉的表 as select * from XXX_拉取后的表@datacenter