Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    66

    Unanswered: Spooling 2 files at a time from oracle 9i

    Hi ,

    Is it possible to spool 2 files at a time?The table is in Oracle 9i and from the single table I want to spool the data in two files.
    If the table have 10 columns and 50 million rows then ,
    one file will contain 7 columns with 50 million data
    and
    second file will contain rest 3 columns with 50 millions of data.


    Any suggestions will be highly appreciated ..
    himridul

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

    Re: Spooling 2 files at a time from oracle 9i

    You could:

    1) Use UTL_FILE to write to two separate files on the server simultaneously

    2) Spool to a single file, and then write a post-processor to read the file and split it into two. This could be a C program, SED script or whatever you are familiar with.

  3. #3
    Join Date
    Jan 2004
    Posts
    66

    Re: Spooling 2 files at a time from oracle 9i

    Thanks andrewst ..
    I don't know which one will be better for spooling 80 millions of data.
    Actually I've to spool 80+80 millions of data simultaneously.
    Ok , I will try both the options , what u suggested.
    Thanks again ..
    himridul

Posting Permissions

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