1 、创建目录及授权
create directory exttab as 'c:'
GRANT READ ON DIRECTORY exttab TO test;
GRANT WRITE ON DIRECTORY exttab TO test;
2、存放数据文件test.txt
3、创建外部表
CREATE TABLE test
(name CHAR(31),
age number)
ORGANIZATION EXTERNAL
(TYPE ORACLE_LOADER
DEFAULT DIRECTORY exttab
ACCESS PARAMETERS(RECORDS DELIMITED BY NEWLINE
FIELDS TERMINATED BY ',')
LOCATION('test.txt'))
4、校验外部表
select * from test
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/143904/viewspace-1006187/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/143904/viewspace-1006187/