ÃÖ±æÈ£
[LIST]
|
2022-06-14 17:18:09, Á¶È¸ : 262 |

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