oracle 数据导入导出

1、导出txt

select * into

outfile "d:/dataout.txt"

fields terminated by "|"

lines terminated by "\n"

from export_test



2、导入txt



load data

infile "d:/dataout.txt"

into import_test

fields terminated by "|"

lines terminated by "\n"





3、替换特定字符

select *,replace(adstract,char(10)," ") into

outfile "d:/dataout.txt"

fields terminated by "|"

lines terminated by "\n"

from export_test



1、从将234的表复制到 本机

copy from hps/hps@suda234 to scott/guojianbing@ORCL replace CHINA_PATENT using select * from USR_DATA_INP.CHINA_PATENT;

2、将本机的表复制到71

copy from scott/guojianbing@ORCL to hps/hps@suda71 replace CHINA_PATENTusing select * from CHINA_PATENT



set long 150;
set copycommit 1
set arraysize 150



1、创建DBLINK

create public database link link234tome connect to hps identified by hps using 'suda234';

2、导入一般表

copy from hps/hps@suda234 to scott/guojianbing@ORCL replace TB_MOBIL_TEXT using select * from TB_MOBIL_TEXT;



3、导入clob表(不能运行成功,不能通过DBLINK执行ddl语句,可以手动建一个空表 执行如下insert语句)

create table TB_MOBIL_TEXT as select * from TB_MOBIL_TEXT@LINK234TOME;



4、

insert into TB_MOBIL_TEXT@link71 select * from TB_MOBIL_TEXT



5、查看已经创建的DBLINK

select * from dba_objects where object_type='DATABASE LINK'



6、删除一个dblink

DROP PUBLIC DATABASE LINK dblinkname
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值