Re: about storage

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Thu, 12 Jun 2003 08:13:09 +0200
Message-ID: <bc95p1$ggd46$1@ID-152732.news.dfncis.de>

If You really want to be it *50M*, set initial = next = 50M and maxextents to 1 (but I would not do that, it is likely just a waste). If You set both to 1M and maxextents 50 (or 100k and maxextents = 500), it again *can* grow to 50M in total, as Sybrand says.

Maxextents is only an upper bound; it is better to worry about initials and nexts - or even better go for LMTs.

hth, Jan

"Emily Liao" <emilyl_at_skytelemedia.com> schrieb im Newsbeitrag news:bc8tr9$g69rp$1_at_ID-189319.news.dfncis.de...
> Sorry, how can I create a table which size is 50M. Is the following right
>
> CREATE TABLE "SCOTT"."A5"("EMPNO" NUMBER(5) NOT NULL, "EMPNAME"
> VARCHAR2(20) NOT NULL)
> TABLESPACE "DB_TST1"
> STORAGE ( INITIAL 1M NEXT 1M MINEXTENTS 1 MAXEXTENTS 500
> PCTINCREASE 0)
>
> "Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
> news:9ctfevg8sb4cgvretbkbdi3n9bisv6snr6_at_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 Thu Jun 12 2003 - 01:13:09 CDT