26 lines
952 B
SQL
26 lines
952 B
SQL
-- -----------------------------------------------------------------------------------
|
|
-- File Name : https://oracle-base.com/dba/monitoring/table_indexes.sql
|
|
-- Author : Tim Hall
|
|
-- Description : Displays index-column information for the specified table.
|
|
-- Requirements : Access to the DBA views.
|
|
-- Call Syntax : @table_indexes (schema-name) (table-name)
|
|
-- Last Modified: 15/07/2000
|
|
-- -----------------------------------------------------------------------------------
|
|
SET LINESIZE 500 PAGESIZE 1000 VERIFY OFF
|
|
|
|
COLUMN index_name FORMAT A30
|
|
COLUMN column_name FORMAT A30
|
|
COLUMN column_position FORMAT 99999
|
|
|
|
SELECT a.index_name,
|
|
a.column_name,
|
|
a.column_position
|
|
FROM all_ind_columns a,
|
|
all_indexes b
|
|
WHERE b.owner = UPPER('&1')
|
|
AND b.table_name = UPPER('&2')
|
|
AND b.index_name = a.index_name
|
|
AND b.owner = a.index_owner
|
|
ORDER BY 1,3;
|
|
|
|
SET PAGESIZE 18 VERIFY ON |