Against LONG: 5) Those are stored in-line and can easily become a performance headache (with chaining etc..)
- Kirti --- Arup Nanda <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
