6 Replies Latest reply: Dec 3, 2012 6:54 AM by EdStevens RSS

    Spool sqlplus everytime

    user12050217
      Hi,
      Oracle 11.2.0.1
      Windows

      I know that how to use spool, but I want that whenever I login to sqlplus then all the sqlplus's command and output should be transferred to c:\sqlspool\file<date+time>.txt i.e. suppose I login to sqlplus at 10:05:10 AM then there should be file like c:\sqlspool\file01121210-05-10.txt. And then if I exit and after some time I again login then file should be something like this : c:\sqlspool\file01121210-15-22.txt i.e. file+dd+mm+yy+hh+mi+ss.txt.

      Thanks.