Solved

1.Increase the MAXEXTENTS parameter value in the initialization file

Posted on 2010-09-14
4
1,314 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Oracle function to insert records? 15 82
SQL2016 to ORACLE11G linked-server 6 79
Checking for column width 8 49
Oracle perfomance tuneing. 3 47
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 recover a database from a user managed backup
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

738 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