Solved

how to zip created files

Posted on 2008-10-30
3
1,196 Views
Last Modified: 2013-12-07
how to compress created files
0
Comment
Question by:Macaw
3 Comments
 
LVL 73

Accepted Solution

by:
sdstuber earned 50 total points
ID: 22841864
pl/sql can't compress an external file directly.

You will have to use a java stored procedure or an external procedure to invoke a zip/compress utility for whatever file you want to compress.

If you are on 10g or higher you can use the dbms_scheduler to invoke an external program too.

In all cases though you'll be invoking something else
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
report returning null 21 93
Oracle Public Synonyms and Privileges 2 65
Oracle - Query link database loop 8 38
error in my cursor 5 29
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question