lister les index d 27une table oracle
Solutions on MaxInterview for lister les index d 27une table oracle by the best coders in the world
{{#items}}
{{text}}
{{/items}} {{ctaText}}
{{#items}} {{/items}}
showing results for - "lister les index d 27une table oracle"
Yannic
26 Nov 2020
1SELECT *
2FROM ALL_INDEXES -- or DBA_INDEXES or USER_INDEXES
3WHERE TABLE_NAME = 'MY_TABLE' AND OWNER = 'MY_OWNER';
4
5-- Indexes columns
6SELECT TABLE_NAME, INDEX_NAME, COLUMN_NAME
7FROM DBA_IND_COLUMNS -- or ALL_IND_COLUMNS
8WHERE TABLE_OWNER = 'MY_OWNER' AND TABLE_NAME = 'MY_TABLE'
9ORDER BY TABLE_NAME, COLUMN_POSITION;similar questions
oracle dblink indexoracle rename tablealter table oracleoracle index partitionoracle list index on tableforce using index oracleoracle table statisticsdrop index oracleoracle index hintrebuild index oracleoracle create index paralleloracle drop index if existsoracle rebuild unusable indexesoracle sql drop indexoracle character indexoracle rename indexhow to select an index in oracle sqloracle function return tableoracle show index columnsoracle create index if not existsoracle foreign key reference tableoracle create indexoracle find unusable indexes your answer for
you will get a confirmation link on this - you will have to click that for successful submission of your answer. we require this to keep the website free of spam, bots and unhelpful content
please ensure to add code which is syntactically corrent and executes properly
ask question on maxinterview
you will get a confirmation link on this - you will have to click that for successful submission of your question. we require this to keep the website free of spam, bots and unhelpful content
please be clear, to the point and respectful