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

Home -> Community -> Usenet -> c.d.o.server -> Help with tablespace sizing.

Help with tablespace sizing.

From: Greg Akins <gakinsNOgaSPAM_at_gatewayhealthplan.com.invalid>
Date: 2000/05/17
Message-ID: <0835fbcf.a913cc37@usw-ex0103-023.remarq.com>#1/1

I'm trying to determine my maximum table size given certian create tablespace parameters.

create tablespace myData datafile
'd:\orant\database\myData.ora' size 150M default storage (
initial 512K
extent 1024K
pctincrease 20
minextents 2
maxextents 121
) ;

It appears that my last extent will be 1024(1.2)^119.

Is this a correct interpretation?

Thanks

-greg

Received on Wed May 17 2000 - 00:00:00 CDT

Original text of this message

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