RE: Extract text from LONG data type into ASCII file

From: Afanassiev, Alex <Alex.Afanassiev_at_team.telstra.com>
Date: Fri, 15 Sep 2000 08:59:35 +1100
Message-Id: <10619.117035@fatcity.com>

Hi Helmut

Would it help you if you use sqlplus set long command ?

SQL> set long 2000000000

With regards
Alex Afanassiev
Oracle DBA, TOC OPS/Internet.Operations

Tel:	(03) 8 661 20 61
Fax:	(03) 9 650 36 74




> -----Original Message-----

> From:	Helmut Daiminger [SMTP:hdaiminger_at_vivonet.com]

> Sent:	Friday, September 15, 2000 6:09 AM

> To:	Oracle DBA List (Lazy DBA) (E-mail); Oracle List (Telelist) (E-mail)

> Subject:	Extract text from LONG data type into ASCII file

>
> Hi!
>
> Is there a way that I can dump the entire contents of a LONG column (that
> contains sql statements) into a plain ASCII file?
>
> How do I do that? If I do it using the spool command, the LONG column gets
> cut off in the middle.
>
> Thanks,
> Helmut
>
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com
> (updated daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
> to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
Received on Thu Sep 14 2000 - 16:59:35 CDT