Re: Long Raw

From: Steve Ashmore <sashmore_at_neonramp.com>
Date: Tue, 6 May 2003 05:51:18 -0500
Message-ID: <vbf4tbktduku0a@corp.supernews.com>

One way you can do it is wby writing a simple PL/SQL procedure, another would be to use exp/imp.

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com
Author of: 'So You Want to be an Oracle DBA?'

"Son of beach" <sonbeach_at_hotmail.com> wrote in message news:3eb768b1_at_shknews01...
> I have a table which contains a data type "Long Raw" format.
> I find that I am fail to copy this field value into other table as
follows:
>
> create table zPTUBLOB as
> (select * from PTUBLOB where 1 = 2)
>
> OR
>
> insert into zPTUBLOB
> (PTUID, STORAGEFLAG, ACTUALRELEASE, ASSIGNEDRELEASE, BLOBDATA)
> (select PTUID, STORAGEFLAG, ACTUALRELEASE, ASSIGNEDRELEASE, BLOBDATA from
> PTUBLOB)
>
> << BLOBDATA is a LONG RAW type field >>
>
> Could you tell me how to do?
>
>
Received on Tue May 06 2003 - 05:51:18 CDT