Solved

1.Increase the MAXEXTENTS parameter value in the initialization file

Posted on 2010-09-14
4
1,311 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 425 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 75 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Need help with fine tuning the windows batch script to change password 9 43
grant user/role question 11 32
SQL Workhours Count beetween Workhours 3 26
Row_number in SQL 6 34
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

828 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