Spooling to a remote server
739411Dec 11 2009 — edited Dec 11 2009Hi *
Is it possible to spool data from Oracle database (using PL/SQL script) to a remote server (without using ftp) such that the file that is created from the database saver is stored onto the remote server.
We do not want to make use of UTL_FILE.\
We are currently running our shell scripts from a remote server which connects to a database.
We want to stored procedures to create a file that will be stored onto the server that has our shell scripsts not on the database.
Could someone please show me an example on how to do that.
Thanks :)