Xref: alice comp.databases.oracle.misc:54230
Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!logbridge.uoregon.edu!news.nero.net!news.uidaho.edu!sea-feed.news.verio.net!news.sierra.com!not-for-mail
From: "Steve McDaniels" <steve.mcdaniels@sierra.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: how to copy the table defination
Date: Fri, 3 Mar 2000 11:44:20 -0800
Organization: Sierra On-Line, Inc.
Lines: 29
Message-ID: <89p50t$1g7$1@plo.sierra.com>
References: <89m55b$t1$1@news.vsnl.net.in>
X-Trace: plo.sierra.com 952112989 1543 209.67.71.100 (3 Mar 2000 19:49:49 GMT)
X-Complaints-To: usenet@plo.sierra.com
NNTP-Posting-Date: 3 Mar 2000 19:49:49 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700


create table my_new_table
storage (initial ... next ... pctincrease ... ) pctfree ... pctused ...
as
select * from my_old_table
/

to just create an identical structure without the data:

create table my_new_table
storage (initial ... next ... pctincrease ... ) pctfree ... pctused ...
as
select * from my_old_table where 1=2
/


"sachh" <sachh@bigfoot.com> wrote in message
news:89m55b$t1$1@news.vsnl.net.in...
> I want to create the table identical to other table with populating it .
> Is there any way round to do it?
> I had tried create table x as select * from y;
> but that populates the table x also.
> i want to create only table.
> regards
> sachin
>
>