Spool using .dat file
NordikJul 5 2010 — edited Jul 5 2010Hi,
I am trying to take a spool of multiple tables using .dat file. The script used in .dat file is given below. The problem is that i am able to log into oracle using this script but enviournment settings and spool doesnot happen. Please help.
sqlplus demo_user/sms123@orcl
echo set lin 10000
echo set pages 50000
echo set trimspool on
echo set colsep ','
echo set feedback off
echo set heading off
echo set arraysize 5000
echo SPOOL c:\abc.txt
echo SELECT * FROM XMLTEST11;
echo SPOOL OFF
echo exit
Edited by: Sonu on Jul 5, 2010 3:02 AM