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

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 08 Sep 2004 19:08:17 -0700
Message-ID: <1094695760.94308@yasure>

Andy Hassall wrote:

> On Tue, 07 Sep 2004 21:36:21 -0700, Daniel Morgan <damorgan_at_x.washington.edu>
> wrote:
>
>

>>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?

>
>
> But the OP is on 9i, not 10g. Then again, 4GB is still a fair bit to be
> dumping through SQL*Plus :-)
>
> Terabytes in a _single field_ is a bit scary...
>

In 10g you can put more into a single column in a single record than will fit on the largest hard disk made.

So given that Oracle created this capability with some purpose in mind ... anyone want to hazard a guess that doesn't involve storing video and audio tape collected by government agencies?

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

Received on Wed Sep 08 2004 - 21:08:17 CDT