Re: how to copy the table defination

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_at_bigfoot.com> wrote in message news:89m55b$t1$1_at_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
>
>
Received on Fri Mar 03 2000 - 13:44:20 CST