Re: Export Oracle table to Flat file

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: squirrel-sql-users-bounces@xxxxxxxxxxxxxxxxxxxxx
[mailto:squirrel-sql-users-bounces@xxxxxxxxxxxxxxxxxxxxx] On Behalf Of
Carolina Barcenas
Sent: Sunday, 08 April, 2007 6:03
To: squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
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




-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV