This discussion is archived
6 Replies Latest reply: Dec 3, 2012 4:54 AM by EdStevens RSS

Spool sqlplus everytime

user12050217 Explorer
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points