janoxley
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!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What additional information would you have required to give us an "A" grade? The "B" is a penalty.