troubleshooting Question

Export data from oracle box to network drive

Avatar of janoxley
janoxleyFlag for United Kingdom of Great Britain and Northern Ireland asked on
Oracle Database
3 Comments2 Solutions1059 ViewsLast Modified:
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!
Join our community to see this answer!
Unlock 2 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros