Operating System - HP-UX
1748186 Members
4303 Online
108759 Solutions
New Discussion юеВ

problem with max extents oracle

 
SOLVED
Go to solution
Mauro Zabalet
Occasional Advisor

problem with max extents oracle



I have east problem with oracle 7,3,2,3 I cannot extend but indice, that I can do? and as I can do it.

This is the error :
he following database error has occurred: ORA-01632: max # extents (505) reached in index CHEMLMS.RS1

Thanks in advance
Unix Adiministrator
6 REPLIES 6
Alexander M. Ermes
Honored Contributor

Re: problem with max extents oracle

Hi Mauro.
If you have access as database administrator,
you should be able to fix this.
You should enhance the next parameter by factor 20 and change the maxextents.
Open the svrmgrl and do the connect internal.
Or open sqlplus as system/passwd.
Then type as shown in sample :
alter index owner.indexname storage (next ..M maxtextents 515 )
;

another thing is to make a note of the storage
parameters of that index, drop it, resize the parameters and rebuild it.
if you need more info, let me know.
Rgds
Alexander M. Ermes
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
Bruno DESQUESNE
Advisor
Solution

Re: problem with max extents oracle

As of Oracle 7.3, you can define unlimited extents :
alter index ... storage (maxextents unlimited);

This will fix your problem. Then you can have a deeper look to set more adequate next extent size.

However, the name of segment you mention looks like a rollback segment. If it is right consider dropping it and recreate it.

Regards
Alexander M. Ermes
Honored Contributor

Re: problem with max extents oracle

Hi Mauro.
Bruno is right, you can go for unlimited extents, but that could give some unwanted results later. If you limit the extents,
you can keep it under control.
rgds
Alexander M. Ermes
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
Mauro Zabalet
Occasional Advisor

Re: problem with max extents oracle

I try to solve but this message appear :
ORA-00406: COMPATIBLE parameter needs to be 7.3.0.0.0 or greater

but the version is 7.3.2.3, I no understand !!!

Thanks for your time
Mauro
Unix Adiministrator
Alexander M. Ermes
Honored Contributor

Re: problem with max extents oracle

Mauro,
go to the init.ora file.
You will find the compatible parameter in there. Set it to the requested value.
Rgds
Alexander M. Ermes
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
Mauro Zabalet
Occasional Advisor

Re: problem with max extents oracle

Dears

I found it the parameters
compatible = 7.3.0.0
And I can Fix the problem.
Thanks for all.
Mauro

Unix Adiministrator