SQL*Plus (MOSC)

MOSC Banner

Sql*Plus Spool Then Zip automatic - Possible?

edited Jun 21, 2012 5:38AM in SQL*Plus (MOSC) 4 commentsAnswered
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?

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center