Results 1 to 3 of 3

Thread: Fast unload

  1. #1
    Join Date
    Jan 2002
    Location
    Toronto
    Posts
    21

    Unanswered: Fast unload

    Hi,

    I need to unload a big Oracle table into a text file (CSV preferable).

    Writing a script SELECT Field1 || ',' || Field2 FROM Table1 and executing it in SQL*Plus is an option but it is slow.

    On the web I found that there is a tool "Fast Unload" from CA.

    Is there anything else? Maybe Oracle9 has something? What do you think of UTL_FILE? Developing a program on PRO*C/C++?

    Thanks,
    Edward

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Fast unload

    Originally posted by EdwardP
    Hi,

    I need to unload a big Oracle table into a text file (CSV preferable).

    Writing a script SELECT Field1 || ',' || Field2 FROM Table1 and executing it in SQL*Plus is an option but it is slow.

    On the web I found that there is a tool "Fast Unload" from CA.

    Is there anything else? Maybe Oracle9 has something? What do you think of UTL_FILE? Developing a program on PRO*C/C++?

    Thanks,
    Edward
    Have a look here for a UTL_FILE approach:

    http://asktom.oracle.com/pls/ask

    Search for the topic called "Can UTL_FILE package used to create ASCII files" - sorry, I tried to create a direct link to it, but it wouldn't work.

    Tom Kyte is an Oracle guru, so if he would do it this way, it's probably a good way!

  3. #3
    Join Date
    Aug 2004
    Posts
    18
    Check out FastReader from WisdomForce (www.wisdomforce.com). FastReader is very fast (unloading 10 million rows in 7 sec into flat file).

Posting Permissions

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