Re: Showstopper ORA-01467: sort key too long - PLEAAASEEE HEEELP

Hi Andrew!
Andrew Protasov <oracle_at_protasov.kiev.ua> wrote:

> Original problem was with too complex group by clause.
> This is from SQL Reference:

> The total number of bytes in all expressions in the GROUP BY
> clause is limited to the size of a data block minus
> some overhead. This size is specified by the initialization
> parameter DB_BLOCK_SIZE.

What will you suggest in case of creating index on the fairy large (600M) table. The total length of (3) indexed fields is less than 60bytes. Attempt to create an index unexpectedly failes with ORA-01467. Renaming table and 'recreting as select' solved the problem. Oracle support is still 'looking into it'. When I find out that I need to recreate index next night should I be prepared for increasing DB_BLOCK_SIZE on a 15G database of the OLTP system (23.99x7)?

--
Sincerely Yours, Konstantin Kivi, Russia, konst_at_sirena.rinet.ru

    aka <k-kivi_at_usa.net>, 2:5020/457.24_at_fidonet.org           Received on Tue Nov 10 1998 - 08:17:55 CST