externaltable

Execute remote script and download files

This module can be used to download files or to run script remotely.

Notes:

~ It is not possible to give an argument to the executable

~ The executable must be stored on the database server

~ The executable must have the execution bit enabled

• To download the temp.sh file stored in /tmp/ in test.txt:

./odat.py externaltable -s $SERVER -d $SID -U $USER -P $PASSWORD --getFile /tmp/ temp.sh test.txt

• To run the temp.sh executable file stored in the /tmp/ folder of the database server:

./odat.py externaltable -s $SERVER -d $SID -U $USER -P $PASSWORD --exec /tmp/ temp.sh