Oracle DBA, How To, Error, Cause and Action

ORA-01685: max # extents (string) reached in index string.stringpartition string

ORA-01685: max # extents (string) reached in index string.string partition string




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.