Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: A Question about DATAFILE AUTOEXTEND Clause

Re: A Question about DATAFILE AUTOEXTEND Clause

From: <sybrandb_at_my-deja.com>
Date: Wed, 27 Sep 2000 06:28:38 GMT
Message-ID: <8qs42j$8c8$1@nnrp1.deja.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US