Message-Id: <10687.122591@fatcity.com> From: Reza Oskouie Date: Tue, 21 Nov 2000 10:14:42 -0000 Subject: Table to Flat File dump Script Please--dump.SQL?? This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C053A3.DD7CFDB0 Content-Type: text/plain 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 ------_=_NextPart_001_01C053A3.DD7CFDB0 Content-Type: text/html Content-Transfer-Encoding: quoted-printable Table to Flat File dump Script Please--dump.SQL??

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