The select command won't copy raw data. This can only be done Through
PL/SQL. The easiest was as I stated was with the export. There are other
methods, but they are complicated and time consuming. If this is a regular
function, then I believe the package is dbms_raw, but I havn't used it in a
very long time.
--
Robert Fazio
Senior Technical Analyst
dbabob_at_yahoo.com
"n" <patelnayan_at_yahoo.com> wrote in message
news:e9046cdc.0107141901.fb197c1_at_posting.google.com...
> > >
> > > create table Pictures
> > > (
> > > pictureId varchar(70),
> > > picture long raw
> > > );
>
> try something like
>
> create table new_table as (select * from pictures);
> and than delete the Pictures table
> and use rename command or something, just look it up in Oracle's
documentation,
> its in there somewhere,
> hope it helped,
> thanks
> take care
Received on Mon Jul 16 2001 - 12:18:35 CDT
