Re: How to initialize varchar2 of infinite length

From: Mladen Gogala <>
Date: Wed, 28 Jan 2015 20:44:02 +0000 (UTC)
Message-ID: <>

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
Je suis Charlie
Received on Wed Jan 28 2015 - 21:44:02 CET

Original text of this message