Re: Insert Statement

Hi Niall

I realize this and it states that you can only insert one row. Perhaps I misread the manual. I am trying to create an archive process for a reporting warehouse an require to copy the contents of the archive table A into table B without removing the table

thanks anyway

Tony

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3f4dfc1b$0$245$ed9e5944_at_reading.news.pipex.net...
> Tony Rees" <tony_rees_at_stratexnet.com> wrote in message
> news:biktm6$ut$1$8300dec7_at_news.demon.co.uk...
> > 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
>
> The insert statement is documented in the sql reference which is part of
the
> oracle docs available at tahiti.oracle.com
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
>
>
Received on Thu Aug 28 2003 - 08:17:37 CDT