you have sqldev on your pc
you have a database on server Y with SSH access from your pc
you have another server on Z with no SSH access from Y
you want to run a query on your PC, then export the results to Y?
I use sql developer on my computer ()let`s say my_localhost) to connect to the oracle database (let`s say REMOUTE_ORACLE_DB_10G2, port 1521).
I have ssh login/password from my_localhost to the remote host (let`s say REMOUTE_LINUX_HOST). No ssh connection from oracle db to the linux host available.
I need to take sql querry results proccessed in REMOUTE_ORACLE_DB_10G2 and export them to the REMOUTE_LINUX_HOST. It`s preferably to use only given connections, no other access rights or connections between oracle db and the linux host are available.
What is the problem?
Sql Developer displays the query results on the client machine. You can then save them to any machine that client machine has access to.
So you can save them to the client in a file and then move that file to any other machine you want.
I have sqldev on my pc.
I have a database on server Y with sql-net 1521 access from my pc.
I have another server on Z with SSH access from my pc.
I`d like to run query on Y and export results to the Z.
Is it possible to do that with Oracle SQL Developer only? What is the best way and what is the key words to read about it in the internet?
Easiest way would be to take your query output from your pc and just sftp it up Z after-the-fact.