Re: rename table/alter initial extent

Graeme Farmer wrote:
>
> Is there a way to rename a table in Oracle 8i.
> I want to change the initial extent setting on a lot of tables
> eg
>
> create table TABLENAME2
> as select * from TABLENAME1;
> drop table TABLENAME1;
> alter table TABLENAME2 rename to TABLENAME1;
>
> or do you have to do
> create table TABLENAME2
> as select * from TABLENAME1;
> drop table TABLENAME1;
> create table TABLENAME1
> as select * from TABLENAME2;
> drop TABLENAME2;
>
> or is there any other method for altering the initial extent (I thought
> about exp/imp but how do you change the value for initial_extent?).
>
> Thanks
> Graeme.

Hi,

If I understand !!!

create table tablename2 STORAGE (initial size[K,M]) as select * from tablename1; Received on Thu Feb 03 2000 - 05:27:41 CST