Re: How to initialize varchar2 of infinite length
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 28 Jan 2015 20:44:02 +0000 (UTC)
Message-ID: <pan.2015.01.28.20.44.34_at_gmail.com>
>
> According to the doc I mentioned, it's 8 TB to 128 TB depending on
> blocksize. Latest releases, mind you.
>
> Indeed.
Date: Wed, 28 Jan 2015 20:44:02 +0000 (UTC)
Message-ID: <pan.2015.01.28.20.44.34_at_gmail.com>
On Wed, 28 Jan 2015 22:40:02 +1100, Noons wrote:
> On 28/01/2015 2:21 AM, Mladen Gogala wrote:
>
>
>> Even CLOB is not infinite, it is at most 2G.
>
> According to the doc I mentioned, it's 8 TB to 128 TB depending on
> blocksize. Latest releases, mind you.
What would you do to a guy who loaded an 8TB LOB into your database? I wouldn't be too happy with such turn of events. Some scenes from the "Dirty Harry" movies come to my mind....
>
>> There is no such thing as infinity.
>
> Indeed.
Unless you're Chuck Norris. He counted to infinity and back. Twice.
-- Mladen Gogala The Oracle Whisperer http://mgogala.byethost5.com Je suis CharlieReceived on Wed Jan 28 2015 - 21:44:02 CET