Wednesday, March 16, 2016

ORA-00904 string: invalid identifier

Hi,
Recently we faced this issue when we renamed a column and changed columns datatype of a table which have a function based index on it.

Symptom:-
   After this change, whenever we were trying to query this table it says above error.


Solution:
   Our problem solved by Rebuilding that function based indexes of this target table.


I hope it will help you to identify the gray area quickly. cheers.

No comments: