|
최길호
[LIST]
|
2022-06-13 20:16:24, 조회 : 401 |
-- 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
CREATE INDEX "SWL_SPEW_PS_I" ON "SWL_SPEW_PS" ("G2_SPATIAL") INDEXTYPE IS MDSYS.SPATIAL_INDEX;
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-13249: SRID 5186 does not exist in MDSYS.CS_SRS table
ORA-29400: data cartridge error
Error - OCI_NODATA
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 10
or
IMP-00003: ORACLE error 29855 encountered
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-13249: internal error in Spatial index: [mdidxrbd]
ORA-13249: Error in Spatial index: index build failed
ORA-13249: Error in spatial index: [mdrcrtxfergm]
ORA-13249: Error in spatial index: [mdpridxtxfergm]
ORA-13200: internal error [ROWID:AAANXiAAHAAABRkAAA] in spatial indexing.
ORA-13206: internal error [] while creating the spatial index
ORA-13365: layer SRID does not match geometry SRID
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I",
select G2_SPATIAL from SWL_SPEW_PS where rownum < 2;
G2_SPATIAL(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO_ORDINATES)
-----------------------------------------------------------------------------------
SDO_GEOMETRY(2001, 5186, SDO_POINT_TYPE(184452.183, 297062.689, NULL), NULL, NULL)
----
조치 : https://nicebury.tistory.com/134
5186 찾아서 insert
--중부원점_2010(GRS80) EPSG:5186 (False_Easting: 200000.0 , False_Northing: 600000.0)
INSERT INTO MDSYS.CS_SRS(CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT)
VALUES ('Korea_2000_Korea_Central_Belt_2010',5186,5186,null,'PROJCS["Korea 2000 Korea Central Belt 2010",GEOGCS["GCS_Korea_2000",DATUM["D_Korea_2000",SPHEROID["GRS 1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Decimal Degree",0.0174532925199433]],PROJECTION["Transverse Mercator"],PARAMETER["False_Easting",200000.0],PARAMETER["False_Northing",600000.0],PARAMETER["Central_Meridian",127.0],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Meter",1.0]]');
SQL> alter index "SWL_SPEW_PS_I" rebuild;
Index altered.
SQL>
MDSYS.CS_SRS 데이터 먼저 넣주면 에러 없겠다.
create table system.CS_SRS2 as
select CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT from MDSYS.CS_SRS
exp / imp
merge into mdsys.SDO_CS_SRS I
using (select CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT from system.CS_SRS2 ) S
on ( I.SRID = S.SRID )
when not matched then
insert (I.CS_NAME, I.SRID, I.AUTH_SRID, I.AUTH_NAME, I.WKTEXT)
values (S.CS_NAME, S.SRID, S.AUTH_SRID, S.AUTH_NAME, S.WKTEXT);
-- OR
insert into mdsys.SDO_CS_SRS (CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT)
(select CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT from system.CS_SRS2
where srid in (
select srid from system.CS_SRS2
minus
select srid from MDSYS.SDO_CS_SRS )
);
set pages 200
ORA-29400: data cartridge error
ORA-1031: insufficient privileges [ 에러 발생조치 ] Importing a Spatial Index Fails with ORA-29855, ORA-13249, ORA-01031 (Doc ID 340521.1)
select 'grant CREATE TABLE, CREATE SEQUENCE to '||username||';' from dba_users order by created;
select 'alter index '||owner||'.'||index_name||' rebuild;' from dba_indexes where DOMIDX_OPSTATUS='FAILED';
set lines 200
set pages 200
col the_ddl for a200
set long 1000000
SELECT dbms_metadata.get_ddl( 'INDEX', 'SPA_IDX','SCOTT' ) FROM dual ;
참고용
delete MDSYS.CS_SRS where srid=5186; -- 지웠다는 메세지 보이지만 안지워진다.
delete MDSYS.SDO_CS_SRS where srid=5186;
select rowid,srid from system.CS_SRS2 where srid=5186;
delete system.CS_SRS2 where rowid='AAAYVyAACAADBdoAAA';
|
3.235.60.197
|
|
12/01 