Re: Create copy of table

create table NEWTABLENAME as select * from OLDTABLENAME nologging;

"Mike" <michael_p_at_blueyonder.co.uk> wrote in message news:A%9H7.20018$mh1.2499073_at_news1.cableinet.net...
> How do I create a new table NEW_TABLE and copy into it all the contents of
> OLD_TABLE without typing out all the column names?
>
>
>
> Mike
>
>
Received on Sat Nov 10 2001 - 08:36:16 CST