Re: ORA-01632 on internal index SYS_C001758?

skubiszewski_at_Eisner.DECUS.Org schrieb:
>
> 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

Hi Rose,

seems to be the index of a unique or primary key constraint. Take a look at 'user_constraint' to get the name of the table. Drop the constraint and rebuild the constriant using the 'USING INDEX'- clause to adjust storage parameters.

HTH
Matthias
--
Matthias.Gresz_at_Privat.Post.DE

Always log on the bright side of life.
http://www.stone-dead.asn.au/movies/life-of-brian/brian-31.htm Received on Thu Dec 10 1998 - 06:26:31 CST