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!

Extracting data into different flat files

user527060Mar 6 2009 — edited Mar 6 2009

I am using oracle 10g.
I've to run a very complex query that will extract/spool around 300 million records. It is so expensive to run the query multiple times. I want to run the query once but spool all the jobs into chunks of different files
so for 300 million records, I want to split the records into 10 different files of 30 million records each. Is it possible to do so??

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 3 2009

Added on Mar 6 2009

13 comments

776 views