Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2010
    Posts
    1

    Unanswered: Toad Question: Export dataset. Out of memory Issue

    Hi guy,

    I used the toad to extract the data from oracle server but I encounter out of memory issue. I have 3 millon++ rows X 15 columns dataset wanna export out the CVS file. Each time, toad extract over 1 million rows then it is show out of memory and terminate.

    I'm using window 7 and i still have enough memory for it. Toad will terminate each time when it consume about 1.7G++. Does anybody know what's happen?

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Use different tool! For example, SQL*Plus with UTL_FILE package.

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Or simply spool and a select
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •