I hope anyone can help me with this because I cannot even find the solution in metalink.
create indextype EXPFilter * ERROR at line 1: ORA-04063: type body "EXFSYS.EXPRESSIONINDEXMETHODS" has errors ORA-06508: PL/SQL: could not find program unit being called: "EXFSYS.EXPRESSIONINDEXMETHODS" ORA-06512: at line 4 grant execute on expfilter to public * ERROR at line 1: ORA-04042: procedure, function, package, or package body does not exist Statistics associated. ASSOCIATE STATISTICS WITH INDEXTYPES EXPFilter * ERROR at line 1: ORA-29815: object being associated is not present PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. Session altered. 18:23:57 SQL>
I'm having problem while installing EXFSYS schema after I have dropped itHow did you DROP it ?
I don't know if you have already used this method and if it could solve the problem.
How To Install and Uninstall Expression Filter Feature or EXFSYS schema [ID 258618.1]