create table newtablename as select * from oldtablename;创建数据库链接,dblinkcreate table newtablename as select * from oldtablename@link_name;
create table tablename as select * from tablename1;
两台机器上的数据,要用数据链 create database link LINKNAME connect to username identified by password using 'db';create table tablename as select * from tablename1@linkname
select * from tablename1;
create database link LINKNAME
connect to username identified by password
using 'db';create table tablename as
select * from tablename1@linkname