copy one table to an other

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.

thanks a lot :)
++
Vince Received on Tue May 10 2005 - 05:21:51 CDT