Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

best way to export content of oracle table to csv file + running compress on file afterwards

user5716448Dec 13 2017 — edited Dec 15 2017

Hi,

using oracle 11.2.0.3 and wish to export content of oracle table approx 3 million rows weekly to a csv file.

Had thought at first could possibly use external table and write into external table - we use this for reading data but when tried insert said operation not supported.

Would rather not use sqlplus spool

could look to use utl_file

Any thoughts on options as ways this can be done which are quick and best current practice.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 12 2018
Added on Dec 13 2017
#general-database-discussions
26 comments
3,469 views