Re: ORA-1631: max # extents 505 reached in table CTXSYS.DR$INDEX_ERROR
From: Yaroslav Perventsev <p_yaroslav_at_cnt.ru>
Date: Wed, 25 Jul 2001 10:25:27 +0400
Message-ID: <9jlodo$rm7$1_at_news247.cnt.ru>
Date: Wed, 25 Jul 2001 10:25:27 +0400
Message-ID: <9jlodo$rm7$1_at_news247.cnt.ru>
Hello!
Firstly you can of course done:
alter table CTXSYS.DR$INDEX_ERROR storage(maxextents 1000); (or more)
but if your table growths very quickly. you need also increase extent size.
alter table CTXSYS.DR$INDEX_ERROR storage(next 10M maxextents 1000);
Of course you need account tablespace size... etc.
Best regards!
Yaroslav.
Bilal EL JOUZOU <bjouzou_at_fluxus.net> ÓÏÏÂÝÉÌ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ:9jk8p7$qpt$1_at_news4.isdnet.net...
> I have the following error in my log file
> "ORA-1631: max # extents 505 reached in table CTXSYS.DR$INDEX_ERROR "
> and I know this are IOT so what shoud I do, I have the ctxsrv runing !
>
> Thnks
>
>
>
>
Received on Wed Jul 25 2001 - 08:25:27 CEST