RE: MINEXTENTS > 1 ?

--0__=6vkmvLMoxSvExP0xN41eMn8GiVUzjw0qiquIT48imF8zpTdjZwa24wJL
Content-type: text/plain; charset=us-ascii Content-Disposition: inline

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)

Subject: RE: MINEXTENTS > 1 ?

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

--0__=6vkmvLMoxSvExP0xN41eMn8GiVUzjw0qiquIT48imF8zpTdjZwa24wJL
Content-type: text/html;

        name="att1.htm"

Content-Disposition: attachment; filename="att1.htm"
Content-transfer-encoding: base64
Content-Description: Internet HTML

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMCBUcmFuc2l0aW9uYWwv L0VOIj4NCjxIVE1MPjxIRUFEPg0KPE1FVEEgSFRUUC1FUVVJVj0iQ29udGVudC1UeXBlIiBDT05U RU5UPSJ0ZXh0L2h0bWw7IGNoYXJzZXQ9aXNvLTg4NTktMSI+DQoNCg0KPE1FVEEgY29udGVudD0i TVNIVE1MIDUuMDAuMjMxNC4xMDAwIiBuYW1lPUdFTkVSQVRPUj4NCjxTVFlMRT48L1NUWUxFPg0K PC9IRUFEPg0KPEJPRFkgYmdDb2xvcj0jZmZmZmZmPg0KPERJVj48Rk9OVCBjb2xvcj0jMDAwMGZm IGZhY2U9QXJpYWwgc2l6ZT0yPjxTUEFOIGNsYXNzPTQ1MzA3MzUxOC0wMTA1MjAwMD5sZXRzIA0K YXNzdW1lIHRoYXQgeW91IGhhdmUgYSBkdyB0YWJsZSB3aGljaCB1IGV4cGVjdCB0byBncm93IGlu IGdpZ3MgLi4geW91IHdvdWxkIA0KcHJvYmFiYWx5IHVzZSBtb3JlIHRoZW4gMSBleHQgdG8gc3Rh cnQgd2l0aCBmb3Igc3VoIHRhYmxlcyBzbyB0aGF0IGl0IGhhcyBhIGJpZyANCnNpemUgdG8gYmVn aW4gd2l0aCAuLjwvU1BBTj48L0ZPTlQ+PC9ESVY+DQo8QkxPQ0tRVU9URSBzdHlsZT0iTUFSR0lO LVJJR0hUOiAwcHgiPg0KICA8RElWIGFsaWduPWxlZnQgY2xhc3M9T3V0bG9va01lc3NhZ2VIZWFk ZXIgZGlyPWx0cj48Rk9OVCBmYWNlPVRhaG9tYSANCiAgc2l6ZT0yPi0tLS0tT3JpZ2luYWwgTWVz c2FnZS0tLS0tPEJSPjxCPkZyb206PC9CPiBXYWx0ZXIgSy4gDQogIFttYWlsdG86YWxkZW4xNDAw NEB5YWhvby5jb21dPEJSPjxCPlNlbnQ6PC9CPiBNb25kYXksIE1heSAwMSwgMjAwMCAxMTo1NiAN CiAgQU08QlI+PEI+VG86PC9CPiBNdWx0aXBsZSByZWNpcGllbnRzIG9mIGxpc3QgT1JBQ0xFLUw8 QlI+PEI+U3ViamVjdDo8L0I+IA0KICBNSU5FWFRFTlRTICZndDsgMSA/PEJSPjxCUj48L0RJVj48 L0ZPTlQ+DQogIDxESVY+PEZPTlQgZmFjZT1BcmlhbCBzaXplPTI+V2hlbiB3b3VsZCB5b3Ugd2Fu dCB0byBzZXQgTUlORVhURU5UUyB0byANCiAgc29tZXRoaW5nIG90aGVyIHRoYW4gJzEnIGZvciBh IHRhYmxlPyBUaGUgb25seSBjYXNlIEkgY2FuIHRoaW5rIG9mIGlzIGlmIEkgYW0gDQogIHRyeWlu ZyB0byBtYW51YWxseSBzdHJpcGUgYSB0YWJsZS90YWJsZXNwYWNlIGFjcm9zcyBtdWx0aXBsZSAN CiAgZGlza3MuPC9GT05UPjwvRElWPg0KICA8RElWPiZuYnNwOzwvRElWPg0KICA8RElWPjxGT05U IGZhY2U9QXJpYWwgc2l6ZT0yPlRoYW5rcy48L0ZPTlQ+PC9ESVY+DQogIDxESVY+PEZPTlQgZmFj ZT1BcmlhbCBzaXplPTI+LXc8L0ZPTlQ+PC9ESVY+PC9CTE9DS1FVT1RFPjwvQk9EWT48L0hUTUw+ DQoNCg== Received on Mon May 01 2000 - 14:59:21 CDT