|
최길호
[LIST]
|
2022-04-08 11:09:18, 조회 : 227 |
alter table ...
ORA-30556: either functional or bitmap join index is defined on the column to be modified
ORA-29885: domain index is defined on the column to be modified
조치안: 관련 index script 확인 / 제거 / alter table / index 생성
set pagesize 0
set linesize 200
col column_name format a20
col TABLE_name format a20
col object_name format a20
col index_name format a25
col table_owner format a10
col index_type format a10
col object_type format a10
COL OWNER format a10
col COLUMN_POSITION head P format 99
col DATA_TYPE format a16
col COLUMN_ID head id format 999
col LAST_ANALYZED format a10
SELECT OWNER,TABLE_NAME,INDEX_NAME,NUM_ROWS,INDEX_TYPE,UNIQUENESS,STATUS,LAST_ANALYZED FROM DBA_INDEXES
where owner = upper('&&owner_name') and table_name in(upper('&&object_name'))
order by OWNER,TABLE_NAME,INDEX_NAME ;
set pagesize 0
set long 90000
SELECT DBMS_METADATA.get_ddL('INDEX','IDX2673714','&&owner_name') from dual;
|
44.200.145.223
|
|
06/05 