where to find info on function based indexes
961716Nov 29 2012 — edited Dec 3 2012Hello,
Using Oracle 11.2, can someone tell me where I can find information about existing Function Based indexes in my database?
I want to shrink the unused space on a table, but there is a FB index that I have to drop in order to shrink the space.
Then, I need to recreate it after I shrink the space.
But how do I find out what functions the index is created to be used for?
I've already looked at dba_indexes, and dba_ind_expressions with no luck.
I see the index, but I don't see what the functions are that are being applied for the FB index.
Thanks in advance.