Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to create a duplicate of a table without copying the data
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