advanced code snippet search

Posted By

geekzspot on 01/11/13


Tagged


Versions (?)

Oracle see what Table and Columns are used in an Index

 / Published in: SQL
 

Useful for tracking down ORA-00001: unique constraint (SCHEMA.INDEX) errors

Expand | Embed | Plain Text 
  1. -- What Table and columns does this Index?
  2. SELECT * FROM user_ind_columns WHERE index_name = UPPER(:index_name); -- Data Dictionary names are UPPERCASE.

Report this snippet  

You need to login to post a comment.