Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Long Raw
Actucally, why do I do that because after I exp the table, then I can't imp
it anymore......
So I want to find out other way to export the data.
"Steve Ashmore" <sashmore_at_neonramp.com> ¼¶¼g©ó¶l¥ó
news:vbf4tbktduku0a_at_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 - 06:15:13 CDT