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 [3206]
		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-13203: failed to read USER_SDO_GEOM_METADATA view

최길호 [LIST]

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

-- ORA-13249: SRID 5186 does not exist in MDSYS.CS_SRS table에러 관련

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

-- create user MDSYS / INSERT INTO MDSYS.CS_SRS 지리정보체계(GIS)

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

--ORA-13203: failed to read USER_SDO_GEOM_METADATA view

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



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



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';

216.73.216.200

LIST

	제목	작성자	작성일	조회
Admin	[ 공지 ] 😃 ================ 필요 할때만 운영 합니다. 안되면 나중에 다시 방문 해주세요~. =================== 😅	최길호	2008/11/26	116
Admin	[ 필요 하신게 있으시면 쪽지 또는 gilho.kr@gmail.com 메일 주세요~ ]	최길호	2006/07/14	136
Admin	create type ORA-39083 ORA-02304	최길호	2025/07/03	0
Script	sms recovery check ORA-00278 정상 복구중.	최길호	2025/07/03	0
Admin	ORA-02019: connection description for remote database not found	최길호	2025/07/03	0
Admin	The clock on host node2 differs from mean cluster time by	최길호	2025/06/27	10
Admin	PRCD-1229 ORA-29701: unable to connect to Cluster Synchronization Service [ 19c grid - 12c SE2 rac ]	최길호	2025/06/26	5
Admin	opatch lsinventory [ LsInventorySession failed: Array index out of range: 0 ]	최길호	2025/06/26	3
Admin	Linux 9 oracle 12.2 install [ /usr/bin/ld: cannot find /usr/lib64/libpthread_nonshared.a ] [ linux 7, 8에서 설치후 사용은 가능 ]	최길호	2025/06/26	2
Admin	windows sqlplus "/as sysdba" ORA-01031: insufficient privileges	최길호	2025/06/16	6
Admin	ORA-00800: soft external error, arguments: [Set Priority Failed]	최길호	2025/06/12	9
Admin	grep /usr/bin/make $ORACLE_HOME/install/make.log [ EE / SE2 ]	최길호	2025/06/09	18
Admin	acfs asmcmd volcreate / srvctl add filesystem / acfsutil size / srvctl start filesystem	최길호	2025/06/05	15
Admin	CRS-2643 PRCD-1302 PRCD-2088 PRKF-1125 PRKF-1241	최길호	2025/06/04	10
Admin	HA web control	최길호	2025/06/02	30