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]

기념일
Search
LINK
+ 가족 Hompy
+ DNSEver
IOTN :: Field Book :: ORACLE

 회원가입

ORA-13249: SRID 5186 does not exist in MDSYS.CS_SRS table
최길호 [LIST]   2022-06-13 20:16:24, 조회 : 21


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

참고용

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

    목록보기   다음페이지 1 [2][3][4][5][6][7][8][9][10]..[145]   [다음 10개]
       

Copyright 1999-2022 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
최근 댓글
2021/06/30
윈도우 서버에서 sqlplus .... ORA-...
by 최길호
2021/06/30
ORA-28500: connection from O...
by 최길호
2019/05/02
pkg 확인 SELECT * FROM AL...
by 최길호
최근 게시물
06/29
[ORACLE]
DDE: Problem Key 'ORA 600 [133....
by 최길호
06/25
[ORACLE]
Replication may not be valid i....
by 최길호
06/22
[운영체제]
CentOS7 홈페이지 Migration 메모.
by 최길호