Re: UNDO Issue
From: The Magnet <art_at_unsu.com>
Date: Wed, 24 Jun 2009 14:24:41 -0700 (PDT)
Message-ID: <ae6d87e6-30fe-4033-be45-1797257a0e5d_at_z34g2000vbl.googlegroups.com>
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
Date: Wed, 24 Jun 2009 14:24:41 -0700 (PDT)
Message-ID: <ae6d87e6-30fe-4033-be45-1797257a0e5d_at_z34g2000vbl.googlegroups.com>
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
Since I am importing, if I turn off logging and set commit = Y, would that help solve the problem?? Received on Wed Jun 24 2009 - 16:24:41 CDT