Re: rename table/alter initial extent

From: Aravind Yalamanchi <ayalaman_at_yahoo.com>
Date: Thu, 03 Feb 2000 09:42:11 -0500
Message-ID: <389993C3.F53B3FF8@yahoo.com>

In Oracle8i, you can use 'alter table .. move storage(initial ...)' as follows :

SVRMGR> create table tab1 (a int, b int) storage (initial 10K); Statement processed.
SVRMGR> select table_name, initial_extent from user_tables;

TABLE_NAME                     INITIAL_EX
------------------------------ ----------
TAB1                                10240

1 row selected.
SVRMGR> alter table tab1 move storage (initial 20K); Statement processed.
SVRMGR> select table_name, initial_extent from user_tables;

TABLE_NAME                     INITIAL_EX
------------------------------ ----------
TAB1                                20480

1 row selected.
SVRMGR> 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.
Received on Thu Feb 03 2000 - 08:42:11 CST