asked on Export data from oracle box to network drive
At Work we have an Oracle server (unix I believe)
On our work network I use SQLLDR to load data to the server and SQLPLUS to extract data.
I tend to have some VBA that runs the SQLPLUS to spool data from tables onto our network drives.
I would like to be able to push data from the Oracle box to our network drives rather than having to pull that data.
I would like to add code to my existing PL/SQL stored procedures to push that data out.
But I don't want to push the data onto the Oracle server, I want to push it to our network drives.
I'm using Windows 7 and the ORacle box is running Oracle 10g.
Hope this request makes sense!
On our work network I use SQLLDR to load data to the server and SQLPLUS to extract data.
I tend to have some VBA that runs the SQLPLUS to spool data from tables onto our network drives.
I would like to be able to push data from the Oracle box to our network drives rather than having to pull that data.
I would like to add code to my existing PL/SQL stored procedures to push that data out.
But I don't want to push the data onto the Oracle server, I want to push it to our network drives.
I'm using Windows 7 and the ORacle box is running Oracle 10g.
Hope this request makes sense!
Oracle Database
Last Comment
slightwv (䄆 Netminder)
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
What additional information would you have required to give us an "A" grade? The "B" is a penalty.