Re: UNDO Issue
From: joel garry <joel-garry_at_home.com>
Date: Wed, 24 Jun 2009 16:12:33 -0700 (PDT)
Message-ID: <299a1d94-7fc0-4989-bfd8-42e5f7acbb4a_at_w35g2000prg.googlegroups.com>
On Jun 24, 2:20 pm, The Magnet <a..._at_unsu.com> wrote:
> 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??
Date: Wed, 24 Jun 2009 16:12:33 -0700 (PDT)
Message-ID: <299a1d94-7fc0-4989-bfd8-42e5f7acbb4a_at_w35g2000prg.googlegroups.com>
On Jun 24, 2:20 pm, The Magnet <a..._at_unsu.com> wrote:
> 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??
Depends what you mean by turn off logging, but probably not. The commit=y may help.
It would help if you would post your exact version. See metalink Note: 460481.1 there's at least one unpublished bug. Also post your exact OS.
jg
-- _at_home.com is bogus. http://www3.signonsandiego.com/stories/2009/jun/24/1n24crash23612-computer-system-under-scrutiny-dc-t/?uniontribReceived on Wed Jun 24 2009 - 18:12:33 CDT