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.