How can I find the columns of a disabled index constraint?

Posted by thecoop on Stack Overflow See other posts from Stack Overflow or by thecoop
Published on 2010-04-20T16:02:48Z Indexed on 2010/04/20 16:13 UTC
Read the original article Hit count: 284

For a normal index constraint, you can find the columns it is on by querying the all_ind_columns sysview using the index name in all_constraints. But if the constraint is disabled, no index exists, and there doesn't seem to be anywhere else that has constraint column information. How can I get the columns of a disabled index constraint from the data dictionary (without re-enabling the constraint)?

© Stack Overflow or respective owner

Related posts about Oracle

Related posts about Constraint