Re: Coping Data From One Table To Another

> >
> > 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 Sat Jul 14 2001 - 22:01:38 CDT