Re: unlimited_rollback_segments = no maxextents?

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Sun, 31 Oct 1999 13:38:03 +0100
Message-ID: <941373524.28766.0.pluto.d4ee154e@news.demon.nl>

unlimited_rollback_segments has NOTHING to do with it. That is for making the number of rollbacksegments unlimited. You should set maxextents unlimited on the default storage clause of your tablespace and on all already existing objects. You will soon notice though, you can't sit back and have Oracle do the spacemanagement for you. The first thing that will probably happen is you run out of tablespace. If you really need the maxextents unlimited option, probably your initial and next extents are way too small. Personally, I try to avoid maxextents unlimited, I would rather be in control myself.

Hth,

--
Sybrand Bakker, Oracle DBA
<alan_psb_at_yahoo.com> wrote in message news:7vh9gj$3ed$1_at_nnrp1.deja.com...
>
>
>
> What parameters should I set such that there is no limitation of the
> maxextents on Oracle 7.3, NT server version? Someone suggests that
> setting unlimited_rollback_segments can do that. However, after I set
> this parameter to TRUE on initsid.ora, the maxextents still reached. Is
> there parameter which related with the maxextents? And what is the use
> of unlimited_rollback_segments?
>
> Thanks,
> Alan
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Oct 31 1999 - 06:38:03 CST