[ 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]
개인폴더 [200]
03.Field Book
Altibase [19]
Tibero [31]
MS-SQL [32]
MySQL [47]
DB2 [79]
ORACLE [3121]
PSQL [139]
CUBRID [5]
기타정보 [178]
운영체제 [618]
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, 조회 : 5,528

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

INSERT INTO MDSYS.CS_SRS (CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT) VALUES ('Google Projection',900913,900913,null,'PROJCS["Google Projection", GEOGCS [ "WGS 84", DATUM ["WGS 84", SPHEROID ["Popular Visualisation Sphere", 6378137, 0]],PRIMEM["Greenwich",0],UNIT["Decimal Degree",0.0174532925199433]],PROJECTION["Mercator"],PARAMETER["Standard_Parallel_1",0],PARAMETER["Central_Meridian",0],PARAMETER["False_Easting",0],PARAMETER["False_Northing",0],UNIT["Meter",1]]');
INSERT INTO MDSYS.CS_SRS (CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT) VALUES ('Google Projection',3857,3857,null,'PROJCS["Google Projection", GEOGCS [ "WGS 84", DATUM ["WGS 84", SPHEROID ["Popular Visualisation Sphere", 6378137, 0]],PRIMEM["Greenwich",0],UNIT["Decimal Degree",0.0174532925199433]],PROJECTION["Mercator"],PARAMETER["Standard_Parallel_1",0],PARAMETER["Central_Meridian",0],PARAMETER["False_Easting",0],PARAMETER["False_Northing",0],UNIT["Meter",1]]');
--서부원점(bassel)- EPSG:5173
INSERT INTO MDSYS.CS_SRS(CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT) VALUES ('Korean 1985 Modified West Belt',5173,5173,null,'PROJCS["Korean 1985 Modified Korea West Belt",GEOGCS["GCS_Korean_Datum_1985",DATUM["D_Korean_Datum_1985",SPHEROID["Bessel 1841",6377397.155,299.1528128]],PRIMEM["Greenwich",0.0],UNIT["Decimal Degree",0.0174532925199433]],PROJECTION["Transverse Mercator"],PARAMETER["False_Easting",200000.0],PARAMETER["False_Northing",500000.0],PARAMETER["Central_Meridian",125.0028902777778],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Meter",1.0]]');                
--중부원점(bassel)- EPSG:5174
INSERT INTO MDSYS.CS_SRS(CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT) VALUES ('Korean 1985 Modified Central Belt',5174,5174,null,'PROJCS["Korean 1985 Modified Korea Central Belt",GEOGCS["GCS_Korean_Datum_1985",DATUM["D_Korean_Datum_1985",SPHEROID["Bessel 1841",6377397.155,299.1528128]],PRIMEM["Greenwich",0.0],UNIT["Decimal Degree",0.0174532925199433]],PROJECTION["Transverse Mercator"],PARAMETER["False_Easting",200000.0],PARAMETER["False_Northing",500000.0],PARAMETER["Central_Meridian",127.0028902777778],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Meter",1.0]]');
--제주원점(bassel)- EPSG:5175
INSERT INTO MDSYS.CS_SRS(CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT) VALUES ('Korean 1985 Modified Central Belt Jeju',5175,5175,null,'PROJCS["Korean 1985_Modified Korea Central Belt Jeju",GEOGCS["GCS_Korean_Datum_1985",DATUM["D_Korean_Datum_1985",SPHEROID["Bessel 1841",6377397.155,299.1528128]],PRIMEM["Greenwich",0.0],UNIT["Decimal Degree",0.0174532925199433]],PROJECTION["Transverse Mercator"],PARAMETER["False_Easting",200000.0],PARAMETER["False_Northing",550000.0],PARAMETER["Central_Meridian",127.0028902777778],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Meter",1.0]]');
--동부원점(bassel)- EPSG:5176
INSERT INTO MDSYS.CS_SRS(CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT) VALUES ('Korean 1985 Modified East Belt',5176,5176,null,'PROJCS["Korean_1985 Modified Korea East Belt",GEOGCS["GCS_Korean_Datum_1985",DATUM["D_Korean_Datum_1985",SPHEROID["Bessel 1841",6377397.155,299.1528128]],PRIMEM["Greenwich",0.0],UNIT["Decimal Degree",0.0174532925199433]],PROJECTION["Transverse Mercator"],PARAMETER["False_Easting",200000.0],PARAMETER["False_Northing",500000.0],PARAMETER["Central_Meridian",129.0028902777778],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Meter",1.0]]');
--동해울릉원점(bassel)- EPSG:5177
INSERT INTO MDSYS.CS_SRS(CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT) VALUES ('Korean 1985 Modified East Sea Belt',5177,5177,null,'PROJCS["Korean 1985 Modified Korea East Sea Belt",GEOGCS["GCS_Korean_Datum_1985",DATUM["D_Korean_Datum_1985",SPHEROID["Bessel 1841",6377397.155,299.1528128]],PRIMEM["Greenwich",0.0],UNIT["Decimal Degree",0.0174532925199433]],PROJECTION["Transverse Mercator"],PARAMETER["False_Easting",200000.0],PARAMETER["False_Northing",500000.0],PARAMETER["Central_Meridian",131.0028902777778],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Meter",1.0]]');
--UTM-K(Bessel 1841) EPSG:5178
INSERT INTO MDSYS.CS_SRS(CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT) VALUES ('Korean_1985_Korea_Unified_Coordinate_System',5178,5178,null,'PROJCS["Korean 1985 Korea Unified Coordinate System",GEOGCS["GCS_Korean_Datum_1985",DATUM["D_Korean_Datum_1985",SPHEROID["Bessel 1841",6377397.155,299.1528128]],PRIMEM["Greenwich",0.0],UNIT["Decimal Degree",0.0174532925199433]],PROJECTION["Transverse Mercator"],PARAMETER["False_Easting",1000000.0],PARAMETER["False_Northing",2000000.0],PARAMETER["Central_Meridian",127.5],PARAMETER["Scale_Factor",0.9996],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Meter",1.0]]');
--UTM-K(GRS80) EPSG: 5179
INSERT INTO MDSYS.CS_SRS (CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT) VALUES ('Korea_2000_Korea_Unified_Coordinate_System',5179,5179,null,'PROJCS["Korea 2000 Korea Unified Coordinate System",GEOGCS["ITRF2000",DATUM["IERS Terrestrial Reference Frame 2000",SPHEROID["GRS 1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Decimal Degree",0.017453293]],PROJECTION["Transverse Mercator"],PARAMETER["False_Easting",1000000.0],PARAMETER["False_Northing",2000000.0],PARAMETER["Central_Meridian",127.5],PARAMETER["Scale_Factor",0.9996],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Meter",1.0]]');
--서부원점(GRS80) EPSG: 5180 (False_Easting: 200000.0 , False_Northing: 500000.0)
INSERT INTO MDSYS.CS_SRS(CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT) VALUES ('Korea_2000_Korea_West_Belt',5180,5180,null,'PROJCS["Korea 2000 Korea West Belt",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",500000.0],PARAMETER["Central_Meridian",125.0],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Meter",1.0]]');
--중부원점(GRS80) EPSG: 5181 (False_Easting: 200000.0 , False_Northing: 500000.0)
INSERT INTO MDSYS.CS_SRS (CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT) VALUES ('Korea_2000_Korea_Central_Belt',5181,5181,null,'PROJCS["Korea 2000 Korea Central Belt",GEOGCS["ITRF2000",DATUM["IERS Terrestrial Reference Frame 2000",SPHEROID["GRS 1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Decimal Degree",0.017453293]],PROJECTION["Transverse Mercator"],PARAMETER["False_Easting",200000.0],PARAMETER["False_Northing",500000.0],PARAMETER["Central_Meridian",127.0],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Meter",1.0]]');
--제주원점(GRS80) EPSG: 5182 (False_Easting: 200000.0 , False_Northing: 550000.0)
INSERT INTO MDSYS.CS_SRS(CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT) VALUES ('Korea_2000_Korea_Central_Belt_Jeju',5182,5182,null,'PROJCS["Korea 2000 Korea Central Belt Jeju",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",550000.0],PARAMETER["Central_Meridian",127.0],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Meter",1.0]]');
--동부원점(GRS80) EPSG: 5183 (False_Easting: 200000.0 , False_Northing: 500000.0)
INSERT INTO MDSYS.CS_SRS(CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT) VALUES ('Korea_2000_Korea_East_Belt',5183,5183,null,'PROJCS["Korea 2000 Korea East Belt",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",500000.0],PARAMETER["Central_Meridian",129.0],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Meter",1.0]]');
--동해울릉원점(GRS80) EPSG: 5184 (False_Easting: 200000.0 , False_Northing: 500000.0)
INSERT INTO MDSYS.CS_SRS(CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT) VALUES ('Korea_2000_Korea_East_Sea_Belt',5184,5184,null,'PROJCS["Korea 2000 Korea East Sea Belt",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",500000.0],PARAMETER["Central_Meridian",131.0],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Meter",1.0]]');
--서부원점_2010(GRS80)  EPSG: 5185 (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_West_Belt_2010',5185,5185,null,'PROJCS["Korea 2000 Korea West 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",125.0],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Meter",1.0]]');
--중부원점_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]]');
--동부원점_2010(GRS80)-EPSG:5187  (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_East_Belt_2010',5187,5187,null, 'PROJCS["Korea 2000 Korea East 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",129.0],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Meter",1.0]]');
--동해(울릉)원점_2010(GRS80)-EPSG:5188  (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_East_Sea_Belt_2010',5188,5188,null,'PROJCS["Korea 2000 Korea East Sea 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",131.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';

18.97.9.172


  LIST

제목 작성자 작성일 조회
Admin  [ 공지 ] 😃 서비스 시간 08:00 ~ 23:00 / 안되면 나중에 다시 방문 해주세요~.😅    최길호 2008/11/26 114
Admin  [ 필요 하신게 있으시면 쪽지 또는 gilho.kr@gmail.com 메일 주세요~ ]    최길호 2006/07/14 135
Troubleshoot  Exception [type: SIGSEGV, Invalid permissions for mapped object] [ADDR:0x0] [PC:0x100137434, kggibr()+52] [flags: 0x0, count: 1]    최길호 2024/10/17 8
Admin  external table blob clob / archive log file    최길호 2024/10/16 12
Admin  ORA-01653: unable to extend table OGG.GGS_DDL_HIST or OGG.GGS_MARKER by 1024 in tablespace OGG    최길호 2024/10/15 6
Admin  ORA-12838 [ commit 필요 ]    최길호 2024/10/04 7
Admin  WARNING: Not enough physical memory for SHM_SHARE_MMU segment of size    최길호 2024/09/18 16
Admin  ORA-07217 [ 폴더 오타 권한 문제 ]    최길호 2024/09/02 5
Admin  C:\Windows\SYSTEM32\ntdll.dll    최길호 2024/08/26 21
Admin  19c sysaux SYS.WRI$_ADV_OBJECTS    최길호 2024/08/16 11
Admin  12c~ Unified Audit record write to audit trail table failed due to ORA-30032.    최길호 2024/08/16 14
Backup and Recovery  ORA-01141: error renaming data file 349 - new file '/oradata/data.dbf' not found    최길호 2024/08/13 9

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

Copyright 1999-2024 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 최길호
최근 게시물
11/21
[PSQL]
CentOS 5 설치 가능 psql 11.22 설치.
by 최길호
10/28
[PSQL]
ERROR: permission denied: "RI....
by 최길호
10/25
[운영체제]
yum install / "Could not resol....
by 최길호