Re: about storage

From: Joel Garry <joel-garry_at_home.com>
Date: 12 Jun 2003 14:24:57 -0700
Message-ID: <91884734.0306121324.6fa2b83e@posting.google.com>

"Emily Liao" <emilyl_at_skytelemedia.com> wrote in message news:<bc8r9n$gqsl6$1_at_ID-189319.news.dfncis.de>...
> CREATE TABLE "SCOTT"."A5"("EMPNO" NUMBER(5) NOT NULL, "EMPNAME"
> VARCHAR2(20) NOT NULL)
> TABLESPACE "DB_TST1"
> STORAGE ( INITIAL 32K NEXT 32K MINEXTENTS 1 MAXEXTENTS 200
> PCTINCREASE 0)
>
> Does that mean the table size is 32K*200=6.4M

It could grow to... 6.25M. (1024*1024 not 1000*1024!)

But of course, being so accurate when using round numbers like 200 smells of over-administrating.

--
@home.com is bogus.
http://www.signonsandiego.com/news/uniontrib/wed/business/news_1b11prgn.html

Received on Thu Jun 12 2003 - 16:24:57 CDT