一、同DB下的表數據復制

ORACLE:

1、SQL>create table ygzhou.new as select * from scheme.old;

2、SQL>copy from system/system@ygzhou create ygzhou.new using select * from scheme.old;

MSSQL SERVER:

     select  * into [ygzhou].[dbo].[new] from [ygzhou].[dbo].[old]

      go

二、跨DB下的數據copy

ORACLE:

1、using dblink

SQL>create table ygzhou.new as select * from scheme.old@dblink_name;

2、SQL COPY

SQL>copy from system/system@ygzhou create ygzhou.new using select * from scheme.old;

MSSQL SERVER:

  select  * into [ygzhou_NEW].[dbo].[new] from [ygzhou].[dbo].[old]

   go

三、跨SERVER下的數據

ORACLE:

同跨DB；

MSSQL SERVER:

利用DBLink

在目的server建立連接到源服務器的link

SELECT *  into  [NEWDB_NAME].[dbo].[NEWTABLE_NAME]  FROM [DBLINK_NAME].[DB_NAME].[dbo].[TABLE_NAME]
GO