Skip to Main Content
  • Questions

  • best way to export large data sets records from toad for oracle to text

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Emmanuel.

Asked: June 11, 2020 - 4:34 pm UTC

Last updated: June 12, 2020 - 2:23 am UTC

Version: toad for oracle 11.5

Viewed 10K+ times! This question is

You Asked

Hi Tom, i am trying to export a 25 million records datafile from toad for oracle to txt or csv but i don't know fast way to do this as my toad for oracle goes out of memory when it gets to 5 million records, pls help, thanks .

and Connor said...

Sounds like a TOAD issue to me.

Easy fix ... just use SQL Plus or SQLcl

set markup csv on
select * from my_table

and you're done


Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.