RE: MINEXTENTS > 1 ?

to make sure that you allocate enough space at the very beginning itself .. ideal for lazy dba's :-)!!

deepAk

-----Original Message-----

From: Winnie_Liu_at_infonet.com [mailto:Winnie_Liu_at_infonet.com] Sent: Monday, May 01, 2000 2: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 - 17:27:18 CDT