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

Hi Tim,
Answers embedded

Hth,
Sybrand Bakker, Oracle 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?

    Depends on the blocksize. Oracle 7.3.4 has maxextents unlimited = clause for every object, so you shouldn't need it, though I don't = recommend using it: things will get out of control

    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?

    Definitely not,

    just alter index <indexname> rebuild

    tablespace xyz

    storage (initial <bigger> next <bigger> pctincrease 0)

    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.

    Just rm -r in a working system won't hurt, it will be automatically = created again. I try to mv it to an 'archive' directory during cold = backups

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