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 [3245]
		PSQL [145]
		CUBRID [5]
		기타정보 [194]
		운영체제 [643]

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,297

-- 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.15

LIST

	제목	작성자	작성일	조회
Admin	[ 공지 ] 😃 ================ 필요 할때만 운영 합니다. 안되면 나중에 다시 방문 해주세요~. =================== 😅	최길호	2008/11/26	116
Admin	[ 필요 하신게 있으시면 쪽지 또는 gilho.kr@gmail.com 메일 주세요~ ]	최길호	2006/07/14	137
Admin	ORA-21780: Maximum number of object durations exceeded.	최길호	2025/09/11	5
Admin	PRVG-0282 : failed to retrieve the operating system distribution ID	최길호	2025/09/08	7
Admin	openSUSE 15.6 Oracle 11.2 / ORA-07445 [nttaddr2bnd()+2158] / dispatchers	최길호	2025/09/08	9
Install and Config	openSUSE 15 oracle 19c	최길호	2025/09/08	9
Admin	PLS-00201: identifier 'DMSYS.DBMS_DM_MODEL_EXP' must be declared	최길호	2025/09/08	4
Admin	impdp CREATE TABLE ... DEFAULT "SCOTT"."ISEQ$$_3969939".NEXTVAL	최길호	2025/09/06	4
Admin	alter table shrink	최길호	2025/08/27	19
Admin	ORA-15028: ASM file not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)	최길호	2025/08/27	14
Admin	12.1 Migrate a Non-Container Database (CDB) to a Pluggable Database (PDB) / cdb to pdb	최길호	2025/08/19	14
Admin	PX Deq: Execute Reply	최길호	2025/08/06	13
SQL,PL*SQL	GROUPING ROLLUP PARTITION BY RULES group by ceil	최길호	2025/08/02	14