ORA-38496: Expression Filter index is not in a valid state



ORA-38496: Expression Filter index is not in a valid state..

Answer / guest

Cause: An attempt was made to REBUILD an Expression Filter
index that was not valid.

Action: Use DEFAULT keyword in the parameters clause to
rebuild the index from defaults or drop and recreate the index.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-16721: unable to set LOG_ARCHIVE_DEST_n parameters

1 Answers  


ORA-02899: smscre: Cannot create SGA with Extended Shared Memory feature

1 Answers  


ORA-09317: szprv: insufficient privileges

1 Answers  


TNS-12601: TNS:information flags check failed

1 Answers  


ORA-36400: (XSSPROP02) workspace object is not a valid variable name.

1 Answers  






NZE-28822: Required seed is not specified.

1 Answers  


ORA-24164: invalid rule engine system privilege: string

1 Answers  


ORA-30570: SEGMENT SPACE MANAGEMENT option already specified

1 Answers  


PLS-00906: Compilation is not possible

1 Answers  


ORA-30085: syntax error was found in overlaps predicate

1 Answers  


ORA-36995: (XSRELGID12) There are duplicate values in the surrogate dimension gid. Use the levelorder option to resolve the ambiguity.

1 Answers  


KUP-04048: internal error parsing record from external data source

1 Answers  


Categories