ORACLE

http://iotn.co.kr 연락처: gilho.kr@gmail.com [ The Japanese government should apologize to Japanese Military Sexual Slavery victim. / 日本政府は日本軍の性的奴隷?牲者に謝罪すべき. ]

사용자

ID:
PW:

INDEX

01.게시판

게시판 [69]

02.File Book

		File 자료실 [95]
		Site Link [18]
		개인폴더 [194]

03.Field Book

		Altibase [19]
		Tibero [30]
		MS-SQL [18]
		MySQL [40]
		DB2 [79]
		ORACLE [2888]
		PostgreSQL [103]
		기타정보 [150]
		운영체제 [577]

04.Q/A Book

Q/A [53]

05.방명록

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

기념일

LINK

+ 가족 Hompy
+ DNSEver

IOTN :: Field Book :: ORACLE

회원가입

ORA-13203: failed to read USER_SDO_GEOM_METADATA view

최길호 [LIST]

2022-06-14 17:18:09, 조회 : 17

DROP TABLE GIS PURGE;

CREATE TABLE GIS (ID NUMBER, SPATIAL SDO_GEOMETRY);

CREATE INDEX GISIDX ON GIS (SPATIAL ) INDEXTYPE IS MDSYS.SPATIAL_INDEX;



ORA-39083: Object type INDEX failed to create with error:

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine

ORA-13203: failed to read USER_SDO_GEOM_METADATA view

ORA-13203: failed to read USER_SDO_GEOM_METADATA view

ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 10



관련: http://iotn.co.kr/power/zboard.php?id=9_1_bbs&no=3078



What Privileges to Grant to a User to Create Spatial Index in a Different Schema (문서 ID 394924.1)



DROP TABLE GIS PURGE;

CREATE TABLE GIS (ID NUMBER, SPATIAL SDO_GEOMETRY);

INSERT INTO GIS VALUES(1,SDO_GEOMETRY(2001, 5186, SDO_POINT_TYPE(184452.183, 297062.689, NULL), NULL, NULL));

COMMIT;

CREATE INDEX GISIDX ON GIS (SPATIAL ) INDEXTYPE IS MDSYS.SPATIAL_INDEX;



SQL> CREATE INDEX GISIDX ON GIS (SPATIAL ) INDEXTYPE IS MDSYS.SPATIAL_INDEX;

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine

ORA-13203: failed to read USER_SDO_GEOM_METADATA view

ORA-13203: failed to read USER_SDO_GEOM_METADATA view

ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 10



SQL> alter INDEX GISIDX rebuild;

ORA-29858: error occurred in the execution of ODCIINDEXALTER routine

ORA-29400: data cartridge error

ORA-01403: no data found

ORA-13249: internal error in Spatial index: [mdidxrbd]

ORA-13203: failed to read USER_SDO_GEOM_METADATA view

ORA-13203: failed to read USER_SDO_GEOM_METADATA view

ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 313



-- exp 파일 열어 보면 INDEX METADATA 다음에

-- INSERT INTO USER_SDO_GEOM_METADATA values ...  확인해서 넣주면 되겠다.

-- 백업시 테이블 백업후 USER_SDO_GEOM_METADATA 에서 테이블,컬럼에 대한 데이터도 백업 하는거 보면 수동으로 

-- USER_SDO_GEOM_METADATA 넣줘야 인덱스가 만들어 진다.



-- 예시

INSERT INTO USER_SDO_GEOM_METADATA values ('GIS','SPATIAL',

mdsys.SDO_dim_array(

MDSYS.SDO_DIM_ELEMENT('X','0','193324.945','.00000005'),

MDSYS.SDO_DIM_ELEMENT('X','0','321122.043','.00000005')),'5186') ;



-- 에러는 나도 인덱스는 있으니 rebuild 하면 된다.

select 'alter index '||owner||'.'||index_name||' rebuild;' from dba_indexes where DOMIDX_OPSTATUS='FAILED';

3.235.78.122

LIST

	제목	작성자	작성일	조회
Admin	[ 공지 ] 😃 서비스 시간 08:00 ~ 23:00 / 안되면 나중에 다시 방문 해주세요~.😅	최길호	2008/11/26	113
Admin	[ 필요 하신게 있으시면 쪽지 또는 gilho.kr@gmail.com 메일 주세요~ ]	최길호	2006/07/14	134
Troubleshoot	DDE: Problem Key 'ORA 600 [13310]' was completely flood controlled (0x6)	최길호	2022/06/29	2
Oracle GoldenGate	Replication may not be valid if the source data has an incompatible character for the target NLS_LANG character set.	최길호	2022/06/25	12
Admin	ORA-14452: attempt to create, alter or drop an index on temporary table already in use	최길호	2022/06/24	6
Admin	external table expdp	최길호	2022/06/18	26
Admin	clob to file / file to clob / clob_to_file / file_to_clob	최길호	2022/06/17	24
Troubleshoot	ORA-13203: failed to read USER_SDO_GEOM_METADATA view	최길호	2022/06/14	17
Troubleshoot	ORA-13249: SRID 5186 does not exist in MDSYS.CS_SRS table	최길호	2022/06/13	22
Troubleshoot	Exception in kzam_upd_props, 942:ORA-00942: table or view does not exist	최길호	2022/06/11	21
Install and Config	Rocky Linux 8.6 Oracle 11.2	최길호	2022/06/03	29
Admin	RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time	최길호	2022/06/02	31
Admin	http://mirror.centos.org/centos/7/os/x86_64/Packages/compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm	최길호	2022/05/30	22
Admin	한글 파일 ORA-22288: 파일 또는 LOB FILEOPEN 작업이 실패되었습니다	최길호	2022/05/26	36
Admin	ORA-00001: unique constraint (SCOTT.TEST_PK) violated	최길호	2022/05/06	212
Troubleshoot	windows ORA-01031: insufficient privileges	최길호	2022/04/22	56
Admin	impdp ORA-01400: cannot insert NULL into , ORA-01449: column contains NULL	최길호	2022/04/19	52