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

From: Reza Oskouie <reza.oskouie_at_digital-dispatch.co.uk>
Date: Tue, 21 Nov 2000 10:14:42 -0000
Message-Id: <10687.122591@fatcity.com>

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>Table to Flat File dump Script Please--dump.SQL??</TITLE>
</HEAD>
<BODY>
 

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


</BODY>
Received on Tue Nov 21 2000 - 04:14:42 CST