Re: create permanent copy of table

On Wed, 20 Oct 1999 21:13:26 GMT, screwbai_at_my-deja.com wrote:

>
>
>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.

create table <blahblah>
as select * from <old_table>
Of course this is a one-time copy.

Hth,

Sybrand Bakker, Oracle DBA

Hth,

Sybrand Bakker, Oracle DBA Received on Wed Oct 20 1999 - 16:46:18 CDT