Re: UNDO Issue
Date: Wed, 24 Jun 2009 14:16:05 -0700 (PDT)
On Jun 24, 4:05 pm, ddf <orat..._at_msn.com> wrote:
> On Jun 24, 3:52 pm, The Magnet <a..._at_unsu.com> wrote:
> > Hi,
> > We're receiving this message: . .
> > importing table "DAILY_CONSENSUS_HST"
> > IMP-00058: ORACLE error 30036 encountered
> > ORA-30036: unable to extend segment by 8 in undo tablespace
> > 'UNDOTBS_1'
> > The undo tablespace has auto extend turned on and the file system is
> > only 50% full with 59GB free. Why are we getting this?? We have
> > free space.......
> You MAY have reached the limit those files will extend as you've hit
> the maximum size configured for autoextend to reach. You really need
> to check all of those settings as MAXSIZE will cause autoextend to
> stop when the file size attains or approaches (within the autoextend
> increment) that maximum value.
> David Fitzjarrell
Hmm...seems pretty annoying. I mean, to me, autoextend with a max size unlimited means it can just grow until the disk is filled. Autoextend having a size limit defeats the meaning of max size unlimited, unless I am missing something. Received on Wed Jun 24 2009 - 16:16:05 CDT