Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: CLOB -> BLOB Conversion
Hi,
I don't know is it possible to do it using simple SQL,
but for example, you can unload table and load it again with SQLLoader.
Unloaded CLOB is same to BLOB. So you can load CLOB into BLOB.
We provide tool that you can use to unload the table with CLOBs (www.ispirer.com/chyfo.html) It generates control file SQLLoader for loading LOBs.
Dmitry.
"Brad Douglas" <B.Douglas_at_astracon.com.au> wrote in message
news:3a9c36c9_5_at_news01.one.net.au...
> Hi,
>
> I'm working on a project to get an existing Oracle8 database supporting
> UTF8. The schema currently contains CLOBs, which cannot be used in a
> multi-byte database. I've tested with BLOBs in a new database - no
problem,
> but I need to come up with a way of upgrading existing customers fom CLOBs
> to BLOBs.
>
> I've gone through the online doco & searched on the oracle tech network
with
> no joy. Can anyone out there give me some guidance no how I might best do
> this.
>
> Thanks in advance,
> Brad
>
>
Received on Wed Feb 28 2001 - 06:20:51 CST