Move file from local to server by ssh or sftp

0

I use the spool to capture the result of a simple query and pass it to a TXT that I place on my local machine in C: \ TXT. But I need to deposit that file in a remote directory using ssh. How could it be done?

I was researching to see if from the spool I could get it for example:

SET PAGESIZE 1000 LINESIZE 200 ECHO OFF TRIMS ON FEEDBACK OFF HEA OFF
SPOOL //100.10.10.99/mnt/mi_directorio/archivo.txt
@consulta.sql;
SPOOL OFF

However this is not supported by SqlPlus.

I saw something from UTP_FILE, but it's not simple. I thought about having the place and move from Linux via console with a batch.

    
asked by Angel Diaz 11.12.2016 в 00:06
source

0 answers