Re: ORA-01632 on internal index SYS_C001758?

In article <F3p9sD.2DI_at_news.decus.org>, skubiszewski_at_Eisner.DECUS.Org () wrote:

> I am seeing an error message ORA-01632 for an index that Oracle
> seems to have internally created on a table. The index is named
> SYS_C001758. The index has reached maxextents and there's no
> way to change this value or PCTINCREASE. The error message says
> that the maximum amount of space allowed for saving undo
> entries has been reached for the named index.
>
> The solution is to increase MAXEXTENTS or PCTINCREASE if
> possible. What's the solution if these aren't possible?
>
> Thanks!
>
> Rose

If you're using 7.3 and higher, there is an alter index rebuild .... command which will re-create the index for you .... you can specify storage parameters.

Dave Lane (dlane_at_pt.lu) Received on Wed Dec 09 1998 - 08:36:48 CST