Skip to content

Instantly share code, notes, and snippets.

@ecormaksin

ecormaksin/oracle_get_indices.sql

Created February 28, 2020 00:27
Show Gist options
  • Save ecormaksin/426f41db50bd21c3811552cdc811ed44 to your computer and use it in GitHub Desktop.
Save ecormaksin/426f41db50bd21c3811552cdc811ed44 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
oracle_get_indices.sql
select index_name, table_owner, table_name, status from user_indexes order by table_name, index_name;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment