Hello,
Firstly, Thank you for taking time to resolve the problem.
I apologize if there are any mistakes in the format used for posting this question.
I have a procedure which generates data in csv file and is loaded to a directory.
I have a requirement to schedule this procedure to be executed every week.
I have successfully done the above two steps.
but the problem am facing is the files are being downloaded to oracle server location directory. but I need the files to be loaded to my own Operating systems file.
I.e My PC is not Database server, but I thought of creating a directory on my own PC's operating system's C:\ drive.
This is a frequently executed procedure so am using dbms_scheduler.
Can we create a directory on our own PC operating System file. I am using Windows 7 OS?
Please find the version details below.
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
Your time and help is very much appreciated.
Thank you