Re: How do you determine initial and next extents ?

Hi,

The DEFAULT storage parameters on a tablespace can be useful for:

• Preventing objects created with no storage clause from being too large or small.
• If you have a dedicated rollback segment tablespace, just set a default storage on the t/s with a minextents of say 10. Then when you create the rollback segs. you don't need a storage clause on them. You can also do this for temporary segments.

However, you should always size individual objects and keep the extent sizes in uniform multiples so the extents are reusable.

Regards,
Andrew.

Keith Kwiatek wrote:
>
> How do you determine initial and next extents when creating a tablespace....
>
> Keith
  Received on Thu Feb 18 1999 - 00:00:00 CET