Sql*Plus Spool Then Zip automatic - Possible?
Hi Gurus,
Ihave an extract activity that consists of a large data output(Approx 800-900mb) file.
I was thinking if i'm gonna use the SQL*Plus and do the @<extract.script> and spool the
output to a TEXT file format. Is there a way i could ZIP the output without my intervention,
I mean, Is there a feature in SQL*Plus that it would automatically zip the file output once done?
Ihave an extract activity that consists of a large data output(Approx 800-900mb) file.
I was thinking if i'm gonna use the SQL*Plus and do the @<extract.script> and spool the
output to a TEXT file format. Is there a way i could ZIP the output without my intervention,
I mean, Is there a feature in SQL*Plus that it would automatically zip the file output once done?
Also, Is it a great deal when it comes to eating up system resources if you'll gonna initiate
sqlplus from the command line(then perform your query/spool) instead of actually launching it using its exe?
0