Solved

1.Increase the MAXEXTENTS parameter value in the initialization file

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

705 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now