A Question about DATAFILE AUTOEXTEND Clause

From: Dino Hsu <dino1_at_ms1.hinet.net>
Date: Wed, 27 Sep 2000 13:38:59 +0800
Message-ID: <8qs15n$8qqmu$1@ID-41926.news.cis.dfn.de>

Dear all,

As in the following example, the initial size of the datafile is 1024M, and can be extended by 2048M. Does the 2048M includes the initial 1024M or not? Is the max size of the datafile 2G or 3G? Thanks in advance.

CREATE TABLESPACE ts_ix_order
DATAFILE 'D:\TWDM\DATFILE\tsorderidx1.ora' size 1024M autoextend on next 512K maxsize 2048M,

'D:\TWDM\DATFILE\tsorderidx2.ora' size 1024M autoextend on next
512K maxsize 2048M

'D:\TWDM\DATFILE\tsorderidx3.ora' size 1024M autoextend on next
512K maxsize 2048M

DEFAULT STORAGE(      INITIAL       512K
        NEXT          512K
        PCTINCREASE   0
        MINEXTENTS    1
        MAXEXTENTS    20000 )

NOLOGGING
ONLINE; Regards,
Dino Received on Wed Sep 27 2000 - 00:38:59 CDT