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

  • From: "Derya Oktay" <deryaoktay@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 11 Sep 2006 11:34:42 +0300

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@xxxxxxxxx> wrote:

Derya, can you be a bit more specific? which segment is growing in your sysaux?

rgds


On 9/11/06, Derya Oktay < deryaoktay@xxxxxxxxx> 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 >


Other related posts:

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