Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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.Received on Tue May 10 2005 - 08:26:05 CDT