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

Home -> Community -> Usenet -> c.d.o.server -> Oracle8: Auextend or Storage (initial...next..)?

Oracle8: Auextend or Storage (initial...next..)?

From: Huy Vu <huyv_at_usa.net>
Date: Sun, 18 Jul 1999 10:44:46 -0400
Message-ID: <tWyk3.24037$jl.22196441@newscontent-01.sprint.ca>


Hi all,

I usually create a tablespace with
Default Storage
(Initial....next...pctincrease...minextents); statement.

I discovered in the Oracle DBA Handbook

another way to extent the segments in the tablespace as

Create tablespace A datafile '/u/tablespaceA.dbf' size 200M autoextend on
next 10MB
Maxsize 250M / ulimited;

How is the pctincrease and minextends value in creatingy a tablespace with this way?

Thanks in advance for any idea.

H.V Received on Sun Jul 18 1999 - 09:44:46 CDT

Original text of this message

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