Re: Table to Flat File dump Script Please--dump.SQL??

You can find dump.sql at http://www.teleport.com/~jkstill/util.

1000+ character lines are not a problem anymore.

Jared

On Tue, 21 Nov 2000, Reza Oskouie wrote:

>
> Hi Guys
> Someone the other day mentioned about dump.sql for dumping tables to flat
> file, could you let me know where I can find this script.
>
> The rows in the table I need to dump are too long maybe over 1kb, I could
> do this through SQLPlus spooling, but not sure it will handle it.
> Is there a limit to SQLPlus out put or just "SET LINESIZE .. " will do?
> There was a limit in UTL_FILE in Oracle 7.3 which could not output lines
> longer than I think 512 Bytes (or something like that), is it still a
> problem in 8.0.5
>
> Thanks for any help.
> Regards
> Reza
>
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address jkstill_at_teleport.com - private Received on Tue Nov 21 2000 - 10:52:59 CST