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 -> Re: rename table/alter initial extent

Re: rename table/alter initial extent

From: Graeme Farmer <g_farmer_at_halas.com.au>
Date: Fri, 4 Feb 2000 09:12:30 +1100
Message-ID: <QYmm4.6330$VJ1.10936@newsfeeds.bigpond.com>


>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. Received on Thu Feb 03 2000 - 16:12:30 CST

Original text of this message

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