Spooling more than one file

[kwartz]

I have several .sql file that I am runing from the dos prompt using echo. I want to spool the log files of each of the .sql files into one. The way I have it now, the current log file overwrites the previous. Can somebody please help me? This is very urgent

Thanks

 
echo spool c:\temp\oracle\script_output.txt >  c:\temp\oracle\tests.sql
echo @c:\temp\oracle\Create_Config.sql      >> c:\temp\oracle\tests.sql
echo spool off                              >> c:\temp\oracle\tests.sql
echo exit;                                  >> c:\temp\oracle\tests.sql
echo                                        >> c:\temp\oracle\tests.sql
 
sqlplusw tryadmin/admin@trydb @c:\temp\oracle\tests.sql
 
echo spool c:\temp\oracle\script_output.txt   > c:\temp\oracle\tests.sql
echo @c:\temp\oracle\text.sql  >> c:\temp\oracle\tests.sql
echo spool off                                >> c:\temp\oracle\tests.sql
echo exit;                                    >> c:\temp\oracle\tests.sql
echo                                          >> c:\temp\oracle\tests.sql
 
sqlplusw tryadmin/admin@trydb @c:\temp\oracle\tests.sql
 

[Dave44]

I have several .sql file that I am runing from the dos prompt using echo. I want to spool the log files of each of the .sql files into one. The way I have it now, the current log file overwrites the previous. Can somebody please help me? This is very urgent

Thanks

 
echo spool c:\temp\oracle\script_output.txt >  c:\temp\oracle\tests.sql
echo @c:\temp\oracle\Create_Config.sql      >> c:\temp\oracle\tests.sql
echo spool off                              >> c:\temp\oracle\tests.sql
echo exit;                                  >> c:\temp\oracle\tests.sql
echo                                        >> c:\temp\oracle\tests.sql
 
sqlplusw tryadmin/admin@trydb @c:\temp\oracle\tests.sql
 
echo spool c:\temp\oracle\script_output.txt   > c:\temp\oracle\tests.sql
echo @c:\temp\oracle\text.sql  >> c:\temp\oracle\tests.sql
echo spool off                                >> c:\temp\oracle\tests.sql
echo exit;                                    >> c:\temp\oracle\tests.sql
echo                                          >> c:\temp\oracle\tests.sql
 
sqlplusw tryadmin/admin@trydb @c:\temp\oracle\tests.sql
 

can you create one file which starts the spool, setting echo on and have that script call all the others that you need to run?

so have like control.sql and within it call all the other scripts that need to be run. as long as none of the others have exit in them they should run through sqlplus as one large script. I use a similar technique.

[kwartz]

Thanks for the help, I first used append but then changed to what you suggested and it worked perfectly, I really appreciate your help.

[kwartz]

I have a log file that is generated from numerous .sql file. I am trying to add a line in the .cmd file that runs these .sql should there be an error in in the log file. This is what I have so far

 
echo spool c:\temp\script_output.txt           > c:\temp\Initialize.sql 
echo @c:\temp\tst1.sql                             >>c:\temp\Initialize.sql 
echo @c:\temp\tst2.sql                             >>c:\temp\Initialize.sql
echo spool off                                           >>c:\temp\initialize.sql 
echo exit;                                                >>c:\temp\Initialize.sql 
echo                                                      >>c:\temp\Initialize.sql
 
 
sqlplusw aduser/admin@tstdb @c:\temp\Initialize.sql
 
FIND "ORA-" "C:\Program Files\DRS\MDIG3\db\script_output.txt"
 

This displays all errors in the log file, however I just want to "echo" errors found .
Can someone please help me with this? This is quite urget need to get it done by cob.
Thanks

[amitpatel66]

Duplicate Threads merged for better management of forum

MODERATOR