Skip to Main Content

APEX

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!

External Tables in Apex?

621951Feb 15 2008 — edited Feb 15 2008
Guys,

Im trying to do the following

I have a csv file which is placed daily by a process in a certain directory. I cant get this placed onto UNIX or else I could schedule up a SQL load for it

I was looking at using external tables for it in order to reference the data directly.

The fall over seems to be when I try and CREATE OR REPLACE DIRECTORY &variable name

The online APEX states that I dont have permissions to do this, is this something that I can request?

I also tried the create table statement with the EXTERNAL arguements minus the default directory but this wasnt valid

Any ideas?

Cheers
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 14 2008
Added on Feb 15 2008
7 comments
920 views