Against LONG:
5) Those are stored in-line and can easily become a performance headache (with chaining etc..)
- Kirti
- Arup Nanda <orarup_at_hotmail.com> wrote:
> Your case against LOB is
>
> (1) desupported in 10i
> (2) Can't replicate through Oracle replication
> (3) Can't do a Create Table As Select if a column is LONG
> (4) LONG columns can't queried like SUBSTR(), INSTR(), DECODE, etc.
>
> You case for them to move from LONG to LOB
>
> (1) All of the above
> (2) The existing data from LONG can be painlessly migrated to LOB using
> TO_LOB()
>
> Their case against moving from LONG
>
> Code change required
>
> You counter argument:
>
> Code change is minimal. Almost all columns that are used as LONG can easily
> be converted to LOB.
>
> Hope this helps.
>
> Arup Nanda
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Monday, June 02, 2003 5:45 PM
>
>
> > We are looking at purchasing a third party software package that is still
> using longs. I am trying to make the case for forcing them to upgrade to
> lob's before we will purchase their software. Aside from the pain of having
> to deal with them - are they going to stop being supported soon? If so do
> you have any urls with details/dates?
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> >
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Kirtikumar Deshpande
INET: kirtikumar_deshpande_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Mon Jun 02 2003 - 21:54:41 CDT