Wednesday, March 16, 2016

ORA-00904 string: invalid identifier

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.

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

   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: