Re: Order of fields in a table.

From: Quarkman <quarkman_at_nowhere>
Date: Sat, 5 Jul 2003 09:19:04 +1000
Message-ID: <3f060b60$0$728$afc38c87@news.optusnet.com.au>

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:nctbgvo2mj21ho67vo0gncvlc2v4oto1cr_at_4ax.com...
> On Sat, 5 Jul 2003 06:46:35 +1000, "Quarkman" <quarkman_at_nowhere>
> wrote:
>
> > LOBS don't suffer the same problem because
> >they are stored out-of-line.
>
>
> By default however they are stored *inline*.

Incorrect, actually.

A BLOB or CLOB bigger than 4000 bytes is ALWAYS stored out-of-line.

Under 4K, you have the choice, and the default there most certainly is to store them inline, as you state. But above that limit, you don't have the choice.

~QM

>In Sqlserver the default
> is out-of-line. So guess what happened when that Sqlserver app was
> implemented on Oracle?
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Fri Jul 04 2003 - 18:19:04 CDT