Re: BLOB storage

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Wed, 05 Mar 2003 09:48:33 -0800
Message-ID: <3E663871.CECDD44@exesolutions.com>

David COSTE wrote:

> I would like to know in which case it advisable or not advisable to store
> blobs in rows.
> I think it is better in each case to store them outside of the row (using
> the DISABLE STORAGE IN ROW clause), given the fact you must first do an
> insert to store your non blob data and then update the row to store the
> BLOBs. This should give more row migration and space fragmentation if you
> have a lot of small blobs.
>
> What do you think ?
>
> David COSTE
> (OCP Candidate)

Since you ask ... I think you need to go to http://tahiti.oracle.com.

There is no relationship between this method and the potential problems you cite.

Daniel Morgan Received on Wed Mar 05 2003 - 11:48:33 CST