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

Vishy Ram wrote:
>
> 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.

create table new_table as select * from old_table WHERE ROWNUM = 0;
                                                  ^^^^^^^^^^^^^^^^

--
Adrian Hands
Raleigh, NC

panic: attempt to recv circular datagram in round socket! panic: stack pointer is read-only!
$ Received on Fri Sep 04 1998 - 23:16:52 CDT