Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> rename table/alter initial extent

rename table/alter initial extent

From: Graeme Farmer <g_farmer_at_halas.com.au>
Date: Thu, 3 Feb 2000 21:17:55 +1100
Message-ID: <txcm4.6098$VJ1.10167@newsfeeds.bigpond.com>

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 - 04:17:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US