Re: Insert Statement

"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. Received on Thu Aug 28 2003 - 14:07:55 CDT