"Tony Rees" <antonie.rees_at_btinternet.com> wrote in message
news:bil326$70m$1$8302bc10_at_news.demon.co.uk...
> Thanks for the suggestion. I tried this and it did not work. It came back
> with an ora-00947 Not enough values
>
> cheers
>
> Tony
>
> "sjacek" <member29683_at_dbforums.com> wrote in message
> news:3295459.1062077864_at_dbforums.com...
> >
> > insert into B select * from A;
> >
> >
[snip]
Does table A and B have the same structure in particular the same number of
columns? I guess that could be the cause of the problem.
--
Onismus \|/
o o
__________________________________oOO_(_)_OOo______________________________
E-Business and Information Management | God said ...
Knowledge Discovery & Dissemination | 1. div D = p
| 2. curl E = -dB/dt
Tel: +27 11 350 3414 | 3. div B = 0
Fax: +27 11 350 8585 | 4. curl H = dD/dt + J
Cel: +27 83 591 5310 | ... and there was light.
___________________________________________________________________________
Received on Thu Aug 28 2003 - 10:18:12 CDT
