Oracle10g 外部表

CREATE DIRECTORY dump_test AS '/oracle/flatfile';
GRANT READ,WRITE ON DIRECTORY dump_test TO public;
DROP TABLE employees;

----------employee.dat-------------
SMITH    CLERK    800
SCOTT    ANALYST    3000
ADAMS    CLERK    1100
MILLER    CLERK    1300

CREATE TABLE employees(ename VARCHAR2(20),
title VARCHAR2(20),
salary number(8)
)
ORGANIZATION EXTERNAL
(TYPE oracle_loader DEFAULT DIRECTORY dump_test ACCESS PARAMETERS
(records delimited BY newline
badfile 'bad_dev' LOGFILE 'log_dev'
fields terminated BY '/t'
( ename CHAR,
title CHAR,
salary CHAR))
LOCATION ('employee.dat')) ;

select * from employees;