Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> 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.Received on Wed Sep 27 2000 - 01:28:38 CDT
![]() |
![]() |