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!

export history table with over 200 columns to CSV file

544158Sep 22 2008 — edited Sep 22 2008

I need to export a history table with over 200 columns and 100mill rec'ds to a csv file. Too many columns to spool output.
I tried to use the dump_csv procedure. I get the invalid path error. I've seen the referrals to "ASKTOM" , I am not a DBA and can not create the directory path. I can not believe, ORACLE does not have a package that does this. I do not want to use TOADs right click and save. I want to automate this. Can someone help me please. I am using 10g.

Thank you
Steve

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 20 2008

Added on Sep 22 2008

16 comments

662 views