spolling 2 files at a time

[himridul]

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 ..

 

[alexhu]

If on UNIX - spool as one file and then 'cut' into 2

Alex

 

[carp]

You can use utl_file to output to two files at once. But spooling only goes to one file.

Elbert, CO
1048 MST