数据库之间的表格复制
例：从wxfctjdb复制表格 到本机orcl数据库 ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA =
(SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) WXFC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = data.sunztech.com.cn)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )
方法1：创建dblink
1、登录本机orcl数据库 打开cmd，输入 sqlplus sys/Oracle123 as sysdba 回车
2、创建数据库连接 1. create database link DDD.REGRESS.RDBMS.DEV.US.ORACLE.COM 2. connect to wxfctjdb identified by wxfctjdb 3. using 'wxfc'; (解释：用户名 identified by 密码 using '（监听器连好的链接名称）') 3、wxfctjdb数据表后面加个@DDD.REGRESS.RDBMS.DEV.US.ORACLE.COM 就可以对表进行操作了。 SELECT * FROM fwdjmxb@DDD.REGRESS.RDBMS.DEV.US.ORACLE.COM 方法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
insert into thp_reginfo select * from view_reginfo 表结构一样，数据复制
create table a as select * from b 创建表
create view view_a as select * from b 创建视图
3、bat法
select table_name from user_tables 查询当前用户下所有表名 创建一个.sql文件
copy from decision/decision@acfc create HOUSE_NATURE using select * from HOUSE_NATURE; copy from decision/decision@acfc create HTBA_CONTRACTBLD using select * from HTBA_CONTRACTBLD; 创建一个.dat文件，引用 .sql文件，log为输出日志文件 @echo off
sqlplus acfc/acfc@orcl @E:\\1.sql > log.txt exit