Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004

    Unanswered: Download data to files


    I have a table that contains about 330 millions of recods .. the problem is that I need ( for a client requierement!) to download those records to a files, each file must contain 10 millions of records .. currently I have a ProC program that do this, declare a cursor, execute a query, open the cursor and write each record to a file ... this procedure is too much slow ! .. The question is .. How can I do this more efficiently? and fastly ! ..

    Thanks a lot!

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    >procedure is too much slow
    Please quantify.
    Without actual facts, any guess is as good as another.
    Where is the time being spent?
    Where's the bottleneck?
    Enable SQL_TRACE to see where Oracle is spending its time.
    Why Pro*C when SQL*PLUS can do the job?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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