One thought on “How to find index or constraint in Oracle?

  1. Satya says:

    You can use SQLs like:

    select * from all_constraints where owner = 'SCHEMA_ONWER_NAME' and constraint_name = 'SYS_C00381400';

    select * from all_indexes where owner='SCHEMA_OWNER_NAME' and index_name='IX_C7057FF7';

Leave a Reply to Satya Cancel reply

Your email address will not be published. Required fields are marked *