RE: MINEXTENTS > 1 ?

Too much work, of course! ;)

Shawn M Ferris
Oracle DBA - Time Warner Telecom

> -----Original Message-----
> From: Winnie_Liu_at_infonet.com [mailto:Winnie_Liu_at_infonet.com]
> Sent: Monday, May 01, 2000 3:15 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: MINEXTENTS > 1 ?
>
>
>
> Umm.. then I have another question, why don't we use ALTER TABLE ..
> ALLOCATE EXTENT to increase the number of extents of the
> table to whatever
> number you wish before you import the table.
>
> Why do we want to use the parameter minextent instead?
>
> Winnie
>
>
>
>
>
> "Thapliyal, Deepak" <DThapliyal_at_ea.com> on 05/01/2000 12:47:31 PM
>
> Please respond to ORACLE-L_at_fatcity.com
>
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> cc: (bcc: Winnie Liu/HQ/ISC)
>
>
>
>
>
> lets assume that you have a dw table which u expect to grow
> in gigs .. you
> would probabaly use more then 1 ext to start with for suh
> tables so that it
> has a big size to begin with ..
>
> -----Original Message-----
> Sent: Monday, May 01, 2000 11:56 AM
> To: Multiple recipients of list ORACLE-L
>
>
> When would you want to set MINEXTENTS to something other than
> '1' for a
> table? The only case I can think of is if I am trying to
> manually stripe a
> table/tablespace across multiple disks.
Received on Mon May 01 2000 - 15:51:30 CDT