Re: Increasing max extents, HP/UX Oracle Ver 7.3.4

>>How does one find out what the systemmax is?

For Oracle 7.3 the max extents is said to be unlimited (actually 2.1 = Billion and some change).

You need to alter the maxextents on the index itself not the tablespace = in which it resides. When you get a chance you could drop the index and = recreate it with a larger next_extent.

>>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?

You can just delete the old alert log whether the database is up or = down. If an alert log exists then Oracle will append to it, if none = exists then Oracle will create one when it needs to write to the alert = log.

Kenny Gump

OCP 7.3 DBA Tim Flynn wrote in message <37717743.57910903_at_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 Thu Jun 24 1999 - 09:57:30 CDT