Re: copy one table to an other

Vince wrote:

> hi there!
> I have to copy data from one table to another..like this:
>
> insert into mytable2 select * from mytable1;
>
> but number of columns of mytable2 is greater than those of mytable1,
> so I get the : ORA-00947: not enough values
>
> is there any way to proceed without having to enumerate all the
> columns ?
> the column in plus is a ID column with an autoincrement (trigger)
> which is not in mytable1.

One way would be to create a view as select * from mytable1, then do

 insert into mytable2 select v.*,null from myview v

-- 
Preston.