Re: about storage

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Thu, 12 Jun 2003 05:38:11 +0200
Message-ID: <9ctfevg8sb4cgvretbkbdi3n9bisv6snr6@4ax.com>

On Thu, 12 Jun 2003 11:20:46 +0800, "Emily Liao" <emilyl_at_skytelemedia.com> wrote:

>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
>

Eventually the table *can* reach 6.4M

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Jun 11 2003 - 22:38:11 CDT