Re: Long Type for replication

From: Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl>
Date: Tue, 23 Sep 2003 20:02:43 +0200
Message-ID: <ef21nvgb5cv03bf0q3gtqnhnecr1oiruve@4ax.com>

On 23 Sep 2003 04:38:06 -0700, andkovacs_at_yahoo.com (Andras Kovacs) wrote:

>Okay I know that Long is type is not supported by any type of
>replication. I know that we have to use cblob instead. However some
>developpers in our office need a detailled explanation why Oracle
>doesn't support Long.
>
>Can somebody help me to explain this ?
>
>Thanks.

The long has a limitation of one long per table. You have to store it inline in your record. As long usually will be large objects, so record is going to be bigger than one database block, hence you will get performance issues, as reading one record will result in several I/Os This can only be resolved by putting the affected column in a separate table, with as primary key the primary key of the original table, hence you're getting controlled redundancy.

LOBs don't have the 1 column per table limitation and they don't have to be stored inline.

If that isn't sufficient explanation and your developers are firmly in the saddle, I would recommend changing jobs.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Sep 23 2003 - 13:02:43 CDT