Oracle如何通过dataLink复制远程数据库的CLOBBLOB字段数据到本地数据库
Jun 07, 2016 pm 05:07 PM我们都知道,Oracle不支持直接通过Database Link复制远程数据库表的CLOB/BLOB字段数据到本地数据库。像如下的SQL是不能执行的。(
我们都知道,Oracle不支持直接通过Database Link复制远程数据库表的CLOB/BLOB字段数据到本地数据库。
像如下的SQL是不能执行的。(ipop_topic表有一个CLOB的字段)
insert into ipop_topic
select * from ipop_topic@prod.us.oracle.com where application_id=1000
但是,我们可以借助全局临时表,,先把数据复制到临时表,再从临时表转移到你的目的表。
create global temporary table ipop_topic_temp
as select * from ipop_topic@prod.us.oracle.com where rownum=1
insert into ipop_topic_temp
select * from ipop_topic@prod.us.oracle.com where application_id=1000
insert into ipop_topic
select * from ipop_topic_temp
commit

Hot Article

Hot tools Tags

Hot Article

Hot Article Tags

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

How to check which table space a table belongs to in Oracle

How to connect to Oracle database using PDO

How to retrieve only one piece of duplicate data in oracle

Implement data import into PHP and Oracle databases

How oracle determines whether a table exists in a stored procedure

How to use PHP and Oracle database connection pools efficiently
