Increasing max extents, HP/UX Oracle Ver 7.3.4

From: Tim Flynn <timflynn_at_noln.com>
Date: Wed, 23 Jun 1999 20:09:40 -0400
Message-ID: <37717743.57910903@noln.com>

Receiving ORA message 1632 telling me MAX EXTENTS of 505 for an INDEX has been exceeded.

I increased the MAX_EXTENTS for the table space to 605. Still receiving the same error message even though I see the command took.

The following is the error message in full detail.

/opt/oracle/admin/fb40/bdump/fb40 - 154 - oerr ora 1632
01632, 00000, "max # extents (%s) reached in index %s.%s"
// *Cause: An index tried to extend past maxextents
// *Action: If maxextents is less than the system max, raise it.
Otherwise,
// you must recreate with larger initial, next or pctincrease
params.
/opt/oracle/admin/fb40/bdump/fb40 - 155 -

Questions:

How does one find out what the systemmax is?

The statement. "Otherwise, you must recreate with larger initial, next or pctincrease params.".
If I need to do this, do I need to take the tablespace offline?

How do I empty the alert file on a Unix machine? Do I rename the and create a new alert file while Oracle is down, or, is there an easier way.

Thank you in advance? Received on Wed Jun 23 1999 - 19:09:40 CDT