ๆŸฅ็œ‹็ดขๅผ•ๆ˜ฏๅฆๅคฑๆ•ˆ

ๆŸฅ็œ‹็ดขๅผ•ๆ˜ฏๅฆๅคฑๆ•ˆ

๐““๐“ธ๐“ท Lv6

ๆฃ€ๆŸฅOracle็ดขๅผ•ๆ˜ฏๅฆๆœ‰ๆ•ˆ

1
2
3
4
5
6
7
8
9
col owner for a10
col table_name for a30
col index_name for a30
col status for a15
col tablespace_name for a15
set linesize 300 pagesize 300
select owner, table_name, tablespace_name, index_name, index_type, status
from dba_indexes
where index_name like '%LIS_REQMAIN%';
  • Title: ๆŸฅ็œ‹็ดขๅผ•ๆ˜ฏๅฆๅคฑๆ•ˆ
  • Author: ๐““๐“ธ๐“ท
  • Created at : 2025-02-13 16:49:25
  • Updated at : 2025-02-18 18:24:55
  • Link: https://www.zhangdong.me/oracle-verify-index-invalid.html
  • License: This work is licensed under CC BY-NC-SA 4.0.
่ฏ„่ฎบ