Re: Oracle9i: How to pull LOB data via SQL*Plus ?

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 07 Sep 2004 21:36:21 -0700
Message-ID: <1094618244.669240@yasure>

cjbj wrote:

> "André Hartmann" <andrehartmann_at_hotmail.com> wrote in message news:<4138944c$1_at_olaf.komtel.net>...
>

>>Hi,
>>
>>  I wonder if the following is possible. Given an Oracle 9i client on
>>Solaris and a ksh (KornShell) there is it possible to write a ksh script and
>>trigger for example SQL*Plus to pull out a BLOB from a remote 9i Oracle
>>Server and store the contents of the LOB in a file on the client ?

>
>
> SQL*Plus currently can fetch CLOBs but not BLOBs.
>
> Can you tell us a little more on how you want to use the data? If a
> future version of SQL*Plus were going to support BLOBs, what
> commands/interface would be useful to you? Do you want the end result
> to be a binary file? Since SQL*Plus output is traditionally character
> based would a column of, say, uuencoded or base64 data be better than
> hex encoding?
>
> -- CJ

and if what is stuffed into that BLOB file is greater than a terabye in size what would you then propose to do with it?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Tue Sep 07 2004 - 23:36:21 CDT