Re: ORA-1631 in V7.0.15.4.0 on Sun4
From: Andrew Finkenstadt <andy_at_vistachrome.com>
Date: Thu, 18 Nov 1993 22:58:19 GMT
Message-ID: <CGpMH7.1A4_at_vistachrome.com>
Date: Thu, 18 Nov 1993 22:58:19 GMT
Message-ID: <CGpMH7.1A4_at_vistachrome.com>
(Gus Teschke) writes:
>ORA-01631 max # extents (99) reached in table sys.icol$
[ deleted ]
>Exactly what is SYS.ICOL$, for starters?
Indexed columns. Parent table is IND$ and is the intersection between COL$ and IND$. Do this as SYS (connect internal)
SQLDBA> alter table ICOL$ storage (maxextents 255);
Andy
-- Andrew Finkenstadt | Systems Analyst, Homes & Land Publishing Corporation +1 904-575-0189 | GEnie Sysop andy_at_genie.geis.com | THE RELATIONAL OATH: "I promise to use the key, the andy_at_homes.com | whole key, and nothing but the key, so help me Codd."Received on Thu Nov 18 1993 - 23:58:19 CET