[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

1.Increase the MAXEXTENTS parameter value in the initialization file

Posted on 2010-09-14
4
Medium Priority
?
1,340 Views
Last Modified: 2012-06-27
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
Comment
Question by:pascal_moise
4 Comments
 
LVL 2

Accepted Solution

by:
jiruiz earned 1700 total points
ID: 33671033
Hi:

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

where <index> is the index of the table ATTACHEDFILES.
0
 
LVL 10

Assisted Solution

by:ravindran_eee
ravindran_eee earned 300 total points
ID: 33671803
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
 
LVL 4

Expert Comment

by:boriskalavsky
ID: 33671897
or you can upgrade  and use ASSM
0
 

Author Closing Comment

by:pascal_moise
ID: 33672061
Thanks both for the solution and the advise,
problem is solved !
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to take different types of Oracle backups using RMAN.
Suggested Courses

612 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question