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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Convert Long Raw to BLOB

Re: Convert Long Raw to BLOB

From: Michael King <mkrol_at_tukan.internet-info.com.pl>
Date: Thu, 17 Jun 1999 11:08:30 GMT
Message-ID: <OG4a3.2799$O5.2644405@news.tpnet.pl>

Valery Yourinsky napisał(a) w wiadomości: <37678e6f_at_mail.softservice.ru>...
>---
>Softservice, Moscow
>ORACLE PARTNER
>tel/fax (095) 333-63-10, 128-18-21
>http://www.softexpress.ru
>ICQ# 368 97 94
>second E-mail: vsur_at_usa.net
>
>Jason <jasben_at_mindspring.com> wrote in message
>news:37473690.61246E86_at_mindspring.com...
>>Look up DBMS_LOB in your Application Developer's Guide, or look in
>>Oracle8 PL/SQL Programming (Oracle Press)
>>
>>Josef Huber wrote:
>>
>>> Oracle 8.0.5
>>> Can i convert my long raws to blobs ?
>>> My long raw's are larger then 65K
>
>
>You can use Oracle 8.1.5 features - TO_LOB function:
>Converts LONG or LONG RAW values in the column long_column to LOB values.
>You can apply this function only to a LONG or LONG RAW
>column, and only in the SELECT list of a subquery in an INSERT statement...
>
>Before using this function, you must create a LOB column to receive the
>
>converted LONG values. To convert LONGs, the LOB column must be of
>
>type CLOB or NCLOB. To convert LONG RAWs, the LOB column must be of type
>BLOB.
>
>
>
>- Export your data from Oracle 8.0.5 using 8.0.5 EXPORT utility
>- Import data to Oracle 8.1.5
>- Convert LONGs to LOBs
>- Export your data from Oracle 8.1.5 using 8.0.5 EXPORT utility
>- Import data to Oracle 8.0.5
>
>Valery Yourinsky
>---
>Softservice, Moscow
>ORACLE PARTNER
>tel/fax (095) 333-63-10, 128-18-21
>http://www.softexpress.ru
>ICQ# 368 97 94
>second E-mail: vsur_at_usa.net
>
>
>
>In Oracle System is DBMS_LOB package( or something like that). This packege
contain function or procedure to convert to LOB. Received on Thu Jun 17 1999 - 06:08:30 CDT

Original text of this message

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