Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: long raw risk

Re: long raw risk

From: Yechiel Adar <adar76_at_inter.net.il>
Date: Thu, 11 Dec 2003 06:39:33 -0800
Message-ID: <F001.005D98DD.20031211063933@fatcity.com>


I have a wild idea but maybe you can check with the vendor if it can be done.

  1. Create a table that will hold only the other fields.
  2. Create a second table that will have the same PK and long raw field.
  3. Create a view that will combine them by the PK.
  4. Since I am not sure in a view with join is updateable you can create instead of trigger that will allow update to the view.

>From the program view it will access one table and you can partition the
first table.

Yechiel Adar
Mehish
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, December 10, 2003 8:29 PM

> Group,
>
> I have just been given a project / database
> where a vendor will implement a table
> with a LONG RAW field in it.
>
> Oracle manuals state clearly that this datatype
> is outdated and should be replaced by BLOB,
> I quoted the manuals to vendor-support, but they
> will not move on this.
>
> From the looks of it, the table with the LR field
> will become the largest table in the system, with
> well over a billion records in it after the 1st yr.
>
> My main worry is inefficiency in retrieving
> records from the table, and most importantly,
> I cannot partition a table with long/longraw
> columns in it.
>
> On first tests, the LRs are >1K, whereas
> the record-without-LR is avg 66 bytes.
> In real-life, the LR is probably bigger still.
>
> Quesions:
> - Is there a real performance-risk ?
> Up to now, I always managed to offload LONG/BLOBs
> into separate tables or into LOB-storage clauses,
> but I see now way to do that here.
> - Given the LongRaw datatype, what are my best
> defences against (potential) performance problems.
>
> Anyone been-there-done-that ?
>
> Regards,
>
> PdV
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Piet de Visser
> INET: piet.de.visser_at_logicacmg.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: Yechiel Adar
  INET: adar76_at_inter.net.il

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 Thu Dec 11 2003 - 08:39:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US