Re: rename table/alter initial extent

Graeme Farmer wrote:
>
> >Hi,
> >
> >If I understand !!!
> >
> >create table tablename2 STORAGE (initial size[K,M]) as select * from
> >tablename1;
>
> Thanks Yvan but I need the table to retain it's original name (just change
> the initial extent).
>
> Graeme.

Ok

create table tablename2 as select * from tablename1; drop table tablename1;
create table tablename1 STORAGE (initial size[K,M]) as select * from tablename2;
drop table tablename2;

--
UNIX n'est pas aime...
Parce qu'avec UNIX un incompetent passe vraiment pour un incompetent... Yvan Galas Oracle & Unix Administrator, +33 (0)155635051 Received on Fri Feb 04 2000 - 04:10:59 CST