Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to create a duplicate of a table without copying the data

Re: How to create a duplicate of a table without copying the data

From: Günter Huerkamp <guenter-huerkamp_at_t-online.de>
Date: 8 Sep 1998 17:09:57 GMT
Message-ID: <6t3od5$9h9$1@news01.btx.dtag.de>


To duplicate a tabe without copying any data try this: create duplicate_table as
select * from original_table
where rownum < 0; Received on Tue Sep 08 1998 - 12:09:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US