Re: Insert Statement

I discovered that the two tables were not exactly the same. Thanks for your effort and putting me right

regards

Tony

"Ed prochak" <ed.prochak_at_magicinterface.com> wrote in message news:4b5394b2.0308281107.5e54f000_at_posting.google.com... > "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;
> > >
> > >
> > >
> > > Originally posted by Tony Rees
> > >
> > > > Dear All,
> > > >
> > > > Can anyone provide the insert statement for me to allow me to copy
> > > > data from
> > > > table A to table B.
> > > >
> > > > ie select into A as select * from B (or something similar)
> > > >
> > > > I know that I can do the following
> > > >
> > > > create table B as select * from A
> > > >
> > > > but this is not what I want to do. Both tables have exactly the
same
> > > > structure. Table B is truncated as part of the process thus
> > > > hanging on to
> > > > it's indexs and other objects
> > > >
> > > > Appreciate help
> > > > regards
> > > > Tony Rees

>
>
> Are you SURE both tables have the same structure??
>
> Also, the Create Table As Select doesn't truncate anything. Your
> reason for not using it doesn't make any sense. Remember, we cannot
> read your mind to get the meaning behind your words.