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 - 07:56:55 CDT
