Re: Long Type for replication

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.
>
>

Need or want? If Oracle says 'don't use it' I would think that alone to be sufficient.

As to why the development tream at Oracle made the decisions it did? I think you would have to have sat in our their discussions unless someone that knows wants to talk about it.

All they need to know is that Oracle is moving to drop them, the storage is less efficient than CLOB and BLOB, the perfomance is worse, and the tools such as those in the DBMS_LOB package don't exist.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)