创建外部表
首先用dba权限创建direcory
create directory extdir as '路径';
再授权给要用的用户
grant read,write on directory extdir to scott;
创建外部表
create table ext_case1
(ename varchar2(10),
job varchar2(20),
sal number)
organization external
(type oracle_loader
default directory extdir
access parameters
(records delimited by newline
skip 6
fields terminated by ","
(ename,job,sal)
)
location('case.ctl') //地址
);
成功
修改directory
alter table ext_tbl_name default directory dir_name;
修改加载路径
alter table ext_tbl_name location ('filename');
加载多个文件只需在指定location属性时同时指定多个文件
alter table ext_case1 location ('ldr_case1.ctl','ext_case1_dat');
a
create directory extdir as '路径';
再授权给要用的用户
grant read,write on directory extdir to scott;
创建外部表
create table ext_case1
(ename varchar2(10),
job varchar2(20),
sal number)
organization external
(type oracle_loader
default directory extdir
access parameters
(records delimited by newline
skip 6
fields terminated by ","
(ename,job,sal)
)
location('case.ctl') //地址
);
成功
修改directory
alter table ext_tbl_name default directory dir_name;
修改加载路径
alter table ext_tbl_name location ('filename');
加载多个文件只需在指定location属性时同时指定多个文件
alter table ext_case1 location ('ldr_case1.ctl','ext_case1_dat');
a
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/28889722/viewspace-1408613/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
11g grid安装
下一篇：
rman备份，基础操作
请登录后发表评论
登录
全部评论
