Home » RDBMS Server » Server Utilities » minextents
minextents [message #69800] Thu, 07 March 2002 23:39 Go to next message
krishna
Messages: 141
Registered: October 1998
Senior Member
What is minextents and maxextents?
Re: minextents [message #69806 is a reply to message #69800] Fri, 08 March 2002 04:57 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
i think oracle explained enough in documentation for all questions u are asking. read documentation first, if u dont understand any thing in documentation then post here and somebody will try to help you.

MAXEXTENTS
The total number of extents, including the first, that can ever be allocated for the segment.

Default: dependent on the data block size and operating system
Minimum: 1 (extent)
Maximum: unlimited

MINEXTENTS
The total number of extents to be allocated when the segment is created. This allows for a large allocation of space at creation time, even if contiguous space is not available.

Default: 1 (extent)
Minimum: 1 (extent)
Maximum: unlimited
Previous Topic: function return boolean ?
Next Topic: Export/Import part of a table
Goto Forum:
  


Current Time: Fri Apr 26 09:45:05 CDT 2024