This content has been marked as final. Show 2 replies
You can try to change character length for VARCHAR2 columns and/or using NUMBER(x) data type declaration and check how Oracle is computing function based index key length with:
See also http://jonathanlewis.wordpress.com/2009/06/05/online-rebuild/.
select column_name, column_length, char_length from user_ind_columns where index_name = 'FUNCINDEX';
Hey, thanks! That shows it defaults to column length of 4000 if not told otherwise. Using CAST in the function results in the index having a length of the size given in that.