Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Fwd: ORA-01688: unable to extend table %s.%s partition %s by %s in tablespace %s

Fwd: ORA-01688: unable to extend table %s.%s partition %s by %s in tablespace %s

From: Derya Oktay <deryaoktay_at_gmail.com>
Date: Mon, 11 Sep 2006 11:34:42 +0300
Message-ID: <35ca1e480609110134q1764a0eo168cfb069dcdf4a5@mail.gmail.com>


Hi Ghassan,
For instance I am getting below error messages, there also exists other segments:

ORA-1688: unable to extend table SYS.WRH$_SEG_STAT partition WRH$_SEG_ST_3099024518_2898 by 128 in tablespace SYSAUX

ORA-1688: unable to extend table SYS.WRH$_ACTIVE_SESSION_HISTORY partition WRH$_ACTIVE_3099024518_2947 by 128 in tablespace SYSAUX Regards

On 9/11/06, Ghassan Salem <salem.ghassan_at_gmail.com> wrote:
>
> Derya,
> can you be a bit more specific? which segment is growing in your sysaux?
>
> rgds
>
>
> On 9/11/06, Derya Oktay < deryaoktay_at_gmail.com> wrote:
> >
> > Hi All,
> > I am recently getting ORA-1688 errors in alert.log. This error is dealt
> > with SYSAUX tablespace and it is happenin again and again everyday. Adding
> > datafile does not work either. We had upgraded to 10g R1 from 9.2database 5 months ago. We had RAC running on AIX 5L. Is ther e anyone having
> > same problem?
> > Any help greatly appreciated. Thanks.
> > Derya OKTAY
> >
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Sep 11 2006 - 03:34:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US