oracle dblink 复制表,Oracle数据库之间表格复制3种方法(bat、dblink、copyfrom)

数据库之间的表格复制

例：从wxfctjdb复制表格到本机orcl数据库

ORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)

WXFC =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = http://www.doczj.com/doc/d477827e16fc700abb68fccf.html)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)

方法1：创建dblink

1、登录本机orcl数据库打开cmd，输入 sqlplus sys/Oracle123 as sysdba 回车

方法2：copy from

1、登录本机orcl数据库打开cmd，输入sqlplus sys/Oracle123 as sysdba 回车

2、复制表格

copy from wxfctjdb/wxfctjdb@wxfc to wxfctjdb/wxfctjdb@orcl create fwdjmxb using select * from fwdjmxb

copy from wxfctjdb/wxfctjdb@wxfc create fwdjmxb using select * from fwdjmxb