一、同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

ITPub博客

表級數據復制