Re: Insert Statement

From: Tony Rees <antonie.rees_at_btinternet.com>
Date: Thu, 28 Aug 2003 15:23:43 +0100
Message-ID: <bil326$70m$1$8302bc10@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
>
> tony_rees_at_stratexnet.com
>
>
> --
> Posted via http://dbforums.com
Received on Thu Aug 28 2003 - 09:23:43 CDT