Re: create permanent copy of table

create table newtable
as select * from oldtable;
becca
>
>
> How do I create a permanet copy of a table. Is there any
other way than
> to do a schema/create and then insert the data?
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
>

--
  This answer is courtesy of QuestionExchange.com   http://www.questionexchange.com/showUsenetGuest.jhtml?ans_id=6338&cus_id=USENET&qtn_id=6292 Received on Mon Oct 25 1999 - 20:59:01 CDT