External Tables in Apex?
621951Feb 15 2008 — edited Feb 15 2008Guys,
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