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;
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;