RE: When will long datatype no longer be supported

From: Richard Ji <Richard.Ji_at_ztango.com>
Date: Mon, 02 Jun 2003 21:59:42 -0800
Message-ID: <F001.005A88CE.20030602215942@fatcity.com>

More against LONG:
(1) Only one LONG column per table, not LOBs. (2) It's easier to manipulate LOBs than LONG, such as you can modify a piece of LOB etc. So this means easier to code.

Richard Ji

-----Original Message-----
Sent: Monday, June 02, 2003 10:55 PM
To: Multiple recipients of list ORACLE-L

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richard Ji
  INET: Richard.Ji_at_ztango.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 Tue Jun 03 2003 - 00:59:42 CDT