Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

"create" command with "organization external" option

497027Mar 11 2006 — edited Mar 12 2006
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 9 2006
Added on Mar 11 2006
2 comments
322 views