Re: A Question about DATAFILE AUTOEXTEND Clause

In article <8qs15n$8qqmu$1_at_ID-41926.news.cis.dfn.de>,   "Dino Hsu" <dino1_at_ms1.hinet.net> wrote:
> 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
>
>

Usually those definitions are covered in the FM, in this case the Oracle Sql Reference manual.

Regards,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com http://www.deja.com/
Before you buy.