Home Database Mysql Tutorial Oracle如何通过dataLink复制远程数据库的CLOBBLOB字段数据到本地数据库

Oracle如何通过dataLink复制远程数据库的CLOBBLOB字段数据到本地数据库

Jun 07, 2016 pm 05:07 PM
oracle database

我们都知道,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

linux

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot Article Tags

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

How to check which table space a table belongs to in Oracle How to check which table space a table belongs to in Oracle Jul 06, 2023 pm 01:31 PM

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

How to connect to Oracle database using PDO How to connect to Oracle database using PDO Jul 28, 2023 pm 12:48 PM

How to connect to Oracle database using PDO

How to retrieve only one piece of duplicate data in oracle How to retrieve only one piece of duplicate data in oracle Jul 06, 2023 am 11:45 AM

How to retrieve only one piece of duplicate data in oracle

Implement data import into PHP and Oracle databases Implement data import into PHP and Oracle databases Jul 12, 2023 pm 06:46 PM

Implement data import into PHP and Oracle databases

How oracle determines whether a table exists in a stored procedure How oracle determines whether a table exists in a stored procedure Jul 06, 2023 pm 01:20 PM

How oracle determines whether a table exists in a stored procedure

How to use PHP and Oracle database connection pools efficiently How to use PHP and Oracle database connection pools efficiently Jul 12, 2023 am 10:07 AM

How to use PHP and Oracle database connection pools efficiently

Does oracle database require jdk? Does oracle database require jdk? Jun 05, 2023 pm 05:06 PM

Does oracle database require jdk?

What are the data types of Oracle? What are the data types of Oracle? Jun 05, 2023 am 11:40 AM

What are the data types of Oracle?

See all articles