while rebuilding index in oracle 126.96.36.199.0 version. on linux getting following error.
SQL> alter index xxxx rebuild;
alter index xxxx rebuild
ERROR at line 1:
ORA-01467: sort key too long
Oracle has given work around for 10g on words....
is there any another alternate...
Another alternative to what?
You haven't posted the alternatives you have tried or what work around by Oracle you are talking about.
ORA-01467 : sort key too long
"Cause: A DISTINCT, GROUP BY, ORDER BY, or SET operation requires a
sort key longer than that supported by ORACLE. Either too many columns
or too many group functions were specified in the SELECT statement.
Action: Reduce the number of columns or group functions involved in