oracle 跨库创建表,Oracle跨库复制表结构

1、首先建立远程连接

create public database link LINK_SJPS

connect to system identified by manager

using '(DESCRIPTION =

(ADDRESS_LIST =

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

)

(CONNECT_DATA =

(SERVICE_NAME = GZZL)

)

)';

2、复制表结构

Create global temporary table TACK_ALLOCATION on commit delete rows as select * from TACK_ALLOCATION@LINK_SJPS.REGRESS.RDBMS.DEV.US.ORACLE.COM

SQL Server跨库复制表数据错误的解决办法

SQL Server跨库复制表数据的解决办法   跨库复制表数据,有很多种方法,最常见的是写程序来批量导入数据了,但是这种方法并不是最优方法,今天就用到了一个很犀利的方法,可以完美在 Sql Serv ...

SQL Server 跨库复制表方法小笔记

insert into tableA (column1,column2.....) SELECT * FROM OPENDATASOURCE('SQLOLEDB', 'Data Source=127. ...

oracle 学习笔记 复制表结构

1.复制表结构以及数据 create table d_table_name as select * from s_table_name;  ---注意并不会创建索