2 Replies Latest reply on Feb 6, 2013 8:54 AM by 989408

    Spooling data from remote server to Local Machine

      Hi Experts,

      Please help, I need to spool data from a remote server using putty(sqlplus) to a local machine. There are credentials i need to give before accessing the remote databases and i am able to do it..i tired with the below query but the spool file(csv or txt) is not able to create on local machine.

      set colsep ,
      set pagesize 120
      set trimspool on
      set headsep off
      set linesize 1000
      set numw

      spool D:\test\myfile.csv

      select table_name, tablespace_name from all_tables;

      spool off

      P.S : I am new to this technology, please help