有几种办法可以选择:
1,使用exp username/password@alias 导出远程数据库,然后在导入,这是最快的.
2,增大TEMP表空间,alter tablespace temp add datafile 'fullpathfilename' size xxxxM;然后建表.
3,分段插入:先建表结构create table tablename as select * from tablename@dblink where 1=2;,再分段插入: insert into tablename select * from tablename@dblink where fieldname between startvalue and endvalue.
commit;
1,使用exp username/password@alias 导出远程数据库,然后在导入,这是最快的.
2,增大TEMP表空间,alter tablespace temp add datafile 'fullpathfilename' size xxxxM;然后建表.
3,分段插入:先建表结构create table tablename as select * from tablename@dblink where 1=2;,再分段插入: insert into tablename select * from tablename@dblink where fieldname between startvalue and endvalue.
commit;
然后分几次insert into new_tb select xxx where 关键字 between xx and xx
笨办法,我是这样解决的。