Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to create a duplicate of a table without copying the data
Hi Gurus,
I am trying to create a temptable which is a duplicate of an existing
table. However
I do not want any data from the master. Just the table definition of the
master. So I
cannot use the Create Table as Select clause. Can anyone suggest a better
way.
Thanks in advance. Received on Fri Sep 04 1998 - 18:34:19 CDT