Re: UNDO Issue
From: ddf <oratune_at_msn.com>
Date: Wed, 24 Jun 2009 14:05:11 -0700 (PDT)
Message-ID: <87a8b9c7-34cf-40c2-beb3-daad65c3183b_at_z34g2000vbl.googlegroups.com>
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.......
Date: Wed, 24 Jun 2009 14:05:11 -0700 (PDT)
Message-ID: <87a8b9c7-34cf-40c2-beb3-daad65c3183b_at_z34g2000vbl.googlegroups.com>
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 Received on Wed Jun 24 2009 - 16:05:11 CDT