indtab.sql
インデックスに紐づくテーブルを確認する
code:SQL
--@indtab <INDNM-前方一致>
define INDNM=&1
set lines 200
set timing off
set verify off
@column_format
select OWNER,TABLE_NAME,INDEX_NAME from all_indexes where INDEX_NAME = upper('&INDNM');
set lines 80
undefine 1 INDNM
@default_settings
■例
SQL> @indtab JHIST_EMPLOYEE_IX
OWNER TABLE_NAME INDEX_NAME
--------------- ------------------------- ------------------------------
HR JOB_HISTORY JHIST_EMPLOYEE_IX