Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: MINEXTENTS > 1 ?
Haha.. I guess that there is a bit more typing involved..
But all I want to say is.. using this method (alter table.. allocate extent..) is more flexible than to set minextents.
What happen if in the future you want to truncate the whole table in the future? You will not left bunch of extents that you don't want. But of course, you can always drop and recreate the table... :P and that's a lot of work also! ; )
Winnie
Shawn Ferris <Shawn.Ferris_at_twtelecom.com> on 05/01/2000 03:08:18 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)
Subject: 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.
>
> Thanks.
> -w
>
>
>
-- Author: Shawn Ferris INET: Shawn.Ferris_at_twtelecom.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You mayReceived on Mon May 01 2000 - 16:41:42 CDT
![]() |
![]() |