ORACLE

[ The imperialist Japanese military must officially acknowledge and apologize for the coercion of young women into sexual slaves. / 幼い女性を性の奴隷にした帝國主義日本軍の?制性を公式に認め、謝罪しなければならない. ]

사용자

ID:
PW:

INDEX

01.게시판

게시판 [72]

02.File Book

		File 자료실 [96]
		Site Link [14]
		개인폴더 [201]

03.Field Book

		Altibase [19]
		Tibero [31]
		MS-SQL [32]
		MySQL [47]
		DB2 [79]
		ORACLE [3211]
		PSQL [143]
		CUBRID [5]
		기타정보 [194]
		운영체제 [634]

04.Q/A Book

Q/A [53]

05.방명록

		방명록 [54]
		레벨업 [37]
		구인/구직 [2]

기념일

LINK

+ 가족 Hompy
+ DNSEver

IOTN :: Field Book :: ORACLE

회원가입

ORA-39911 ORA-08114 / Virtual Indexes NOSEGMENT / INDEX QUEST_SX_IDX.......

최길호 [LIST]

2025-07-06 21:09:42, 조회 : 2

 관련 검색

https://community.oracle.com/mosc/discussion/3970968/object-exists-in-dba-objects-but-nowhere-else

https://toad.yahoogroups.narkive.com/77LwBirW/quest-index-in-dba-objects-but-not-in-dba-indexes



ORA-39911: Index SCOTT.QUEST_SX_IDX45A4FBAF2F19F14DA8 in tablespace USERS points to partition P201412 of table USER.TBLNAME in tablespace TSNAME outside of transportable set.

ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option

ORA-08114: can not alter a fake index



-- DDL

set pagesize 0 long 90000 

select dbms_metadata.GET_DDL('INDEX','QUEST_SX_IDX45A4FBAF2F19F14DA8','SCOTT') from dual;



-- Virtual Indexes (Doc ID 1401046.1)  NOSEGMENT : 인덱스 세그먼트가 생성되지 않는다. 

CREATE INDEX "SCOTT"."QUEST_SX_IDX45A4FBAF2F19F14DA8" ON "SCOTT"."SA_SP_MST" ("SP_NO")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS  NOSEGMENT

CREATE INDEX "SCOTT"."QUEST_SX_IDX5A4FBAF2F10373BE97" ON "SCOTT"."SA_SP_DTL" ("SP_NO")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS COMPRESS 1  NOSEGMENT



-- dba_indexes , dba_segments

select owner,index_name,tablespace_name from dba_indexes where index_name like 'QUEST_SX_IDX%' union all

select owner,segment_name,tablespace_name from dba_segments where SEGMENT_NAME like 'QUEST_SX_IDX%';

no rows selected



-- dba_objects

select owner||'.'||object_name||' '||object_type||' '||last_ddl_time||' '||created||' '||status from dba_objects

 where object_name like 'QUEST_SX_IDX%';



SCOTT.QUEST_SX_IDX45A4FBAF2F19F14DA8 INDEX 2022/10/13 10:28 2022/10/13 10:28 VALID

SCOTT.QUEST_SX_IDX45A4FBAF2F19F17B18 INDEX 2022/10/13 10:28 2022/10/13 10:28 VALID

SCOTT.QUEST_SX_IDX5A4FBAF2F103701F4F INDEX 2022/10/13 10:28 2022/10/13 10:28 VALID

SCOTT.QUEST_SX_IDX5A4FBAF2F103714689 INDEX 2022/10/13 10:28 2022/10/13 10:28 VALID

SCOTT.QUEST_SX_IDX5A4FBAF2F1037289CC INDEX 2022/10/13 10:28 2022/10/13 10:28 VALID

SCOTT.QUEST_SX_IDX5A4FBAF2F10373BE97 INDEX 2022/10/13 10:28 2022/10/13 10:28 VALID



-- 조치

select 'drop '||object_type||' '||owner||'.'||object_name||' ;' from dba_objects where object_name like 'QUEST_SX_IDX%';

drop INDEX SCOTT.QUEST_SX_IDX45A4FBAF2F19F14DA8 ;

drop INDEX SCOTT.QUEST_SX_IDX45A4FBAF2F19F17B18 ;

drop INDEX SCOTT.QUEST_SX_IDX5A4FBAF2F103701F4F ;

drop INDEX SCOTT.QUEST_SX_IDX5A4FBAF2F103714689 ;

drop INDEX SCOTT.QUEST_SX_IDX5A4FBAF2F1037289CC ;

drop INDEX SCOTT.QUEST_SX_IDX5A4FBAF2F10373BE97 ;

216.73.216.123

LIST

	제목	작성자	작성일	조회
Admin	[ 공지 ] 😃 ================ 필요 할때만 운영 합니다. 안되면 나중에 다시 방문 해주세요~. =================== 😅	최길호	2008/11/26	116
Admin	[ 필요 하신게 있으시면 쪽지 또는 gilho.kr@gmail.com 메일 주세요~ ]	최길호	2006/07/14	136
Admin	ALTER SYSTEM SET deferred_segment_creation=FALSE; / database_properties / impdp network_link	최길호	2025/07/07	2
Admin	ORA-39911 ORA-08114 / Virtual Indexes NOSEGMENT / INDEX QUEST_SX_IDX.......	최길호	2025/07/06	2
Admin	impdp Slow While Creating Views / create view [ Event: single-task message ]	최길호	2025/07/04	4
Admin	select username,last_login from dba_users / UPDATE user$ SET spare6 = DECODE(to_char	최길호	2025/07/03	6
Admin	create type ORA-39083 ORA-02304	최길호	2025/07/03	6
Script	sms recovery check ORA-00278 정상 복구중.	최길호	2025/07/03	5
Admin	ORA-02019: connection description for remote database not found	최길호	2025/07/03	3
Admin	The clock on host node2 differs from mean cluster time by	최길호	2025/06/27	12
Admin	PRCD-1229 ORA-29701: unable to connect to Cluster Synchronization Service [ 19c grid - 12c SE2 rac ]	최길호	2025/06/26	9
Admin	opatch lsinventory [ LsInventorySession failed: Array index out of range: 0 ]	최길호	2025/06/26	5
Admin	Linux 9 oracle 12.2 install [ /usr/bin/ld: cannot find /usr/lib64/libpthread_nonshared.a ] [ linux 7, 8에서 설치후 사용은 가능 ]	최길호	2025/06/26	3
Admin	windows sqlplus "/as sysdba" ORA-01031: insufficient privileges	최길호	2025/06/16	9
Admin	ORA-00800: soft external error, arguments: [Set Priority Failed]	최길호	2025/06/12	11