Re: increasing extents because of ORA-01632
From: Daniel Roy <danielroy10junk_at_hotmail.com>
Date: 31 Jul 2003 06:36:20 -0700
Message-ID: <3722db.0307310536.38c89062_at_posting.google.com>
Date: 31 Jul 2003 06:36:20 -0700
Message-ID: <3722db.0307310536.38c89062_at_posting.google.com>
Also,
if you're running at least Oracle 8i, consider locally-managed tablespaces. With those, you don't need to worry anymore about number of extents, pctincrease, ...
Daniel
> I pct_increase = 50, then the first next _extend will be 40969, and the
> following will be 61454, then the next 81938 and so on...
>
> notes that max_extend may take the value UNLIMITED.
Received on Thu Jul 31 2003 - 15:36:20 CEST