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

Home -> Community -> Mailing Lists -> Oracle-L -> Conversion from LONG -> CLOB -> BLOB for 1 TB Table?

Conversion from LONG -> CLOB -> BLOB for 1 TB Table?

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Wed, 17 Jan 2007 15:16:15 +0530
Message-ID: <BBD944BCAC3AB4499DFBAFB1D8AF3020026FF352@BLRKECMSG11.ad.infosys.com>

Folks

Due to Historical Reasons in a Banking product the Customer Signature Image binary data i.e. JPEG (with JFIF Compression) is stored in a LONG Datatype.

What is the ideal path to convert this LONG field to BLOB Datatype in Oracle ver 9.2 & 10gR2?

Is Conversion from LONG to the intermediate CLOB & CLOB onwards to BLOB necessarily needed?

What might be the performance issues faced as Table size is 1 TB?

Any Docs Links will help

Thanks indeed

Some related Metalink Doc IDs:-

<Note:166090.1> How to Migrate LONG to CLOB / LONG RAW to BLOB
<Note:162035.1> Copy CLOB Column Value To BLOB Column

Received on Wed Jan 17 2007 - 03:46:15 CST

Original text of this message

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