Tuesday, August 19, 2008

External table

create or replace directory test_dir as '/bie_oraexp';
grant read,write on directory test_dir to robert;

CREATE TABLE ext_test (id)
ORGANIZATION EXTERNAL
(TYPE oracle_datapump DEFAULT DIRECTORY test_dir LOCATION ('test_table.csv'))
as select * from table1;