SQL & PL/SQL

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!

how to - extract query result set in CSV and make multiple files if result set is huge.

dc5eb82e-f9d6-4928-a94a-8e3b527fda17May 4 2015 — edited May 7 2015

I have a query which returns millions of rows. I need to extract those rows in CSV files. Having said that i want to keep these files under a limit of 500 MB . Result set can be distributed among multiples files but each file can not be > 500 MB in size.

How to achieve this?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 4 2015

Added on May 4 2015

13 comments

2,402 views