"create" command with "organization external" option
497027Mar 11 2006 — edited Mar 12 2006Hi everybody,
I have tried to rus the following command:
create table AAA
( ... table description....)
organization external
(type oracle_loader
default directory ex_dir
access parameters
(records delimeted by newline
badfile 'errors'
logfile 'log'
fields terminated by ';'
(...field description...))
location ('ptimp.txt'))
parallel 5
reject limit 200;
where "ex_dir" was created in advance
create directory ex_dir as 'd:/ptimp.txt';
When I run the commend it throws me the ORA-30657 error:
"operation not supported on external organized table"...
I do not really know what to try... Is it possible that I do not have the "oracle_loader" driver? Is it possible to be the user that I am using?
If you have any ideas... I would appriciate it...
Thanks a lot!
Cristina