创建目录
create or replace directory dir1 as '/export/home1/oracle/test';
create table testload(
name varchar2(22) primary key,
object clob)
装载脚本
declare
l_clob clob;
l_bfile bfile;
amt number:=dbms_lob.lobmaxsize;
src_offset number :=1;
dst_offset number :=1;
charset varchar2(32);
charsetid number;
lang_ctx number :=dbms_lob.default_lang_ctx;
warning number;
begin
select value into charset from v$nls_parameters where parameter='NLS_CHARACTERSET';
select nls_charset_id(charset) into charsetid from dual;
insert into testload values('test1',empty_clob()) returning object into l_clob;
l_bfile:=bfilename('DIR1','11.txt');
dbms_lob.fileopen(l_bfile);
dbms_lob.loadclobfromfile(l_clob,l_bfile,amt,dst_offset,src_offset,charsetid,lang_ctx,warning);
dbms_lob.fileclose(l_bfile);
commit;
end;
详细见一篇文章
http://logzgh.itpub.net/post/3185/22312