How to CREATE DIRECTORY use local directory
855947May 31 2011 — edited May 31 2011Hi, all
I want to get some data to local machine from remote database service, so I use a store procedure to get those date and write them to a file, before execute the procedure, I have to use CREATE DIRECTORY to ensure path of the file.
I use CREATE DIRECTORY on local machine use OCCI, like: "CREATE OR REPLACE DIRECTORY MSGDIR AS 'C:\test'", and I can not find the file under C:\test, I find answer on internet about this problem, It looks that CREATE DIRECTORY use the directory on the database service rather than local machine.
Anybody knows how to CREATE DIRECTORY use local directory?
Or have any advice to get data to local machine in my case?
Best Regards.