数据库之间的表格复制
例:从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