dump contents of ORA table on Unix in a flat file on client (PC)? 1

[hosrow]

I am trying to dump the contents of a oracle table on the server (UNIX) into a file on the client side (PC), on a daily basis with date and time as part of the file name. Any ideas?

 

[Swany]

Schedule a sqlplus session on the server using cron. Have the sqlplus script always spool the file to the same name, then have the shell script rename it.

Install openSSH on the server and the client. If the server already has SSH then you don't have to install it there. You can use rcp and rsh but since they aren't secure you are better off just going with openSSH.

I installed cygwin then downloaded and compiled the SSH source w/out problems.

Create a scripts on the client to retrieve files from the server and remove them when they have transmitted successfully. (Use scp to copy the files by filespec, use ssh to rm the files that you download)

 

[Swany]

I have scripts that you can use if you need them..

CYGWIN can be found here:

http://sources.redhat.com/cygwin/

It is an environment for compiling U*NIX/Linux sources on Windows 9X/NT/2K environmetns.

OpenSSH can be found at

http://www.openssh.net/

OpenSSH is a free implementation of the SSH (Secure Shell)
software daemon and client.