Home » SQL & PL/SQL » SQL & PL/SQL » Multiple Flat File Generation in one spool (Oracle 9i)
Multiple Flat File Generation in one spool [message #383610] Thu, 29 January 2009 05:29 Go to next message
vboppa
Messages: 22
Registered: November 2008
Junior Member
Dear Forum,

I need to generate a flat file for 200 Million records, I want to generate multiple files instead one.

By using spool command How can i generate multiple files?

Which one is best either spool or UT_FILE package (There is processing/conditions of data required?

Thanks
Vasu
Re: Multiple Flat File Generation in one spool [message #383612 is a reply to message #383610] Thu, 29 January 2009 05:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Execute a new spool command each time you want to change the file.

Neither is best in all cases otherwise the other one would no more exist.

Regards
Michel

[Updated on: Thu, 29 January 2009 05:33]

Report message to a moderator

Re: Multiple Flat File Generation in one spool [message #383616 is a reply to message #383610] Thu, 29 January 2009 05:45 Go to previous messageGo to next message
vboppa
Messages: 22
Registered: November 2008
Junior Member
Pls read following sentense as

Which one is best either spool or UTL_FILE package (There is No processing/conditions of data required)?
Re: Multiple Flat File Generation in one spool [message #383631 is a reply to message #383616] Thu, 29 January 2009 06:40 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
spool -> client
utl_file -> server

Regards
Michel
Previous Topic: Wheter FORALL works for DML operations only
Next Topic: Pass Checkbox Parameters from HTML Form to a stored procedure (merged)
Goto Forum:
  


Current Time: Thu Dec 08 16:08:02 CST 2016

Total time taken to generate the page: 0.11768 seconds