create / public / database link dblinkname
connect to dbusername identified by dbpassword
using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 备份库IP)(PORT = 备份库port)))(CONNECT_DATA =(SERVICE_NAME = 备份库name)))';
do something from 表@dblinkname
//create table xxx as select * from 表@dblinkname
收起