Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1330
  • Last Modified:

1.Increase the MAXEXTENTS parameter value in the initialization file

Dear,
I have an error when trying to attach a file in our database oracle 8i,
error is ORA-01632: max # of extents num reached in index name
the table used is called ATTACHEDFILES

action to resolve this Oracle error are:
1.Increase the MAXEXTENTS parameter value in the initialization file.
2.Increase the PCTINCREASE parameter value in the initialization file.

My problem is where do I have to make those modification,
in an init file on the oracle server ? with dba studio in the table ATTACHEDFILES ?

Thanks for help
0
pascal_moise
Asked:
pascal_moise
2 Solutions
 
jiruizCommented:
Hi:

 Try
                          ALTER INDEX <index> STORAGE ( MAXEXTENTS UNLIMITED);

where <index> is the index of the table ATTACHEDFILES.
0
 
ravindran_eeeCommented:
My suggestion would be not to alter PCTINCREASE. Better to change MAXEXTENTS to UNLIMITED. Already the SQL statement for making the change has been provided. You can issue the statement by logging into SQL Plus. Remember, it is a change to the object only. You are not doing any database level change.

You might run into the same issue with another table or index. You can follow the same steps. Or you can pro-actively change it for all the objects! Better to set MAXEXTENTS to UNLIMITED for all the objects. To avoid doing this manually, you can set the storage parameter for the tablespace itself, so that all the new objects by default will have it set as UNLIMITED.
0
 
boriskalavskyCommented:
or you can upgrade  and use ASSM
0
 
pascal_moiseAuthor Commented:
Thanks both for the solution and the advise,
problem is solved !
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now