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

The parameters next and maxsize
have nothing to do with the parameters
for the tablespace. They simply state
how the datafile should extend. The
parameters for the tablespace are still set with default storage ( .....

Krister Lundmark

Huy Vu <huyv_at_usa.net> wrote in message
news:tWyk3.24037$jl.22196441_at_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 Aug 01 1999 - 13:09:25 CDT