Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: about storage
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 Wed Jun 11 2003 - 23:04:17 CDT