|
From: Matthew D. <mda...@ja...> - 2007-04-08 17:33:01
|
CB, I think this is a case where SQuirreL won't be the right tool for the job. I suspect you'll either need a hand-coding solution or a different tool. Hand-coding could be as simple as using SQL*Plus, turning spooling on, and running select * from your table. Of course you'll need to tweak SQL*Plus's params a bit... but that's the basic idea. It's too bad that Oracle doesn't offer tools like Sybase's bcp or Teradata's FastExport to do what you want. A different tool like Oracle Data Integrator (ODI) might be better. It has built-in tools like OdiSqlUnload designed to unload data from a table to a file. It may be using a canon to swat a fly--there may be more setup and config time needed than your relatively modest requirement merits. But it's an option (it's free to download from oracle.com). Then again, maybe one of the SQuirreL gurus will know of a clever way to easily redirect the output of a query to a flat file without requiring the whole dataset to be held in memory. It doesn't seem like it ought to be too difficult to achieve. Good luck. -Matt -----Original Message----- From: squ...@li... [mailto:squ...@li...] On Behalf Of Carolina Barcenas Sent: Sunday, 08 April, 2007 6:03 To: squ...@li... Subject: [Squirrel-sql-users] Export Oracle table to Flat file I am new Squirrel User. How can I export an Oracle table (1 Million records) to a flat file? I am having problems with the size limit. When I try to bring up all the table it can't handle. I could always break the table in pieces but I am wondering if there is an easier way. I appreciate any suggestions. CB _________________________________________________________________ Cant afford to quit your job? Earn your AS, BS, or MS degree online in 1 year. http://www.classesusa.com/clickcount.cfm?id=866145&goto=http%3A%2F%2Fwww.c lassesusa.com%2Ffeaturedschools%2Fonlinedegreesmp%2Fform-dyn1.html%3Fsplov r%3D866143 |
