I am looking for any suggestions to get data from an oracle table to a flat csv file on a windows server.
I am using oracle 11.2G running on oracle enterprize linux 5.9.
I have so far created a flat csv file on the oracle server using utl_file. My issue is i cant seem to transfer this file from the oracle server to windows server.
The options i have looked at are filezilla to use scp or rcp. I have even considered ftp but issues making sure the windows process doesnt pick file up before i have sent it all (all the checks to do to make sure file gets there ok e,g size/format).
I was running single line unix commands using the host command procedure 1) scp/rcp 2)unix script with all ftp cmds and checks in.
Any simpler or better options would be much appreciated.
When you say this, "but issues making sure the windows process doesn't pick file up before i have sent it all", do you mean you are pulling the file directly back into the working directory? What I would normally do is pull the file back into a temp directory, then once that is complete, move it to the working directory. Provided the temp and working directory are on the same disk/array, this should be almost instantaneous.
I would probably use command line WinSCP (or something similar) to grab the file using the method described above.
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: https://oracle-base.com
My blog: https://oracle-base.com/blog
Who is online
Users browsing this forum: No registered users and 1 guest