1.Increase the MAXEXTENTS parameter value in the initialization file
Posted on 2010-09-14
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