http://iotn.co.kr 연락처: gilho.kr@gmail.com [ The Japanese government should apologize to Japanese Military Sexual Slavery victim. / 日本政府は日本軍の性的奴隷?牲者に謝罪すべき. ]

사용자

ID:
PW:

INDEX
01.게시판
게시판 [71]
02.File Book
File 자료실 [95]
Site Link [17]
개인폴더 [201]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [25]
MySQL [43]
DB2 [79]
ORACLE [3003]
PSQL [134]
기타정보 [155]
운영체제 [603]
04.Q/A Book
Q/A [53]
05.방명록
방명록 [54]
레벨업 [37]
구인/구직 [2]

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

 회원가입

create user MDSYS / INSERT INTO MDSYS.CS_SRS 지리정보체계(GIS) 공간정보 /
최길호 [LIST]   2023-04-05 10:20:31, 조회 : 229

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


-- http://oracle-solutions.com/install-oracle-spatial-11-2-0-4/
-- https://www.durham.computer/2020/03/invalid-mdsys-schema.html

conn /as sysdba
drop user MDSYS cascade;
create user MDSYS identified by mdsyspwd ;
@?/md/admin/mdprivs.sql
-- 아닌경우도 있다 alter session set current_schema="MDSYS";
@?/md/admin/mdprivs.sql;
@?/md/admin/mdinst.sql;


-- 10g 에러 발생시
ORA-29534: referenced object MDSYS.oracle/spatial/geocoder/common/GeocoderAddress could not be resolved
조치 : execute the following scripts to re-install the XDK component.(문서 ID 1112494.1)
conn /as sysdba
@?/xdk/admin/rmxml.sql
@?/xdk/admin/initxml.sql
-- 다시 mdinst.sql 실행
conn /as sysdba
@?/md/admin/mdinst.sql;


select object_name||' '||object_type||' '||status from dba_objects where owner='MDSYS' and status='INVALID';
SELECT comp_id, control, schema, version, status, comp_name FROM dba_registry WHERE comp_id in ('SDO','JAVAVM','XML');


-- https://nicebury.tistory.com/134  [ oracle spatial 에 한국좌표계 정보 ]

--구글 좌표계
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]]');

3.235.60.197


  LIST

제목 작성자 작성일 조회
Admin  [ 공지 ] 😃 서비스 시간 08:00 ~ 23:00 / 안되면 나중에 다시 방문 해주세요~.😅    최길호 2008/11/26 113
Admin  [ 필요 하신게 있으시면 쪽지 또는 gilho.kr@gmail.com 메일 주세요~ ]    최길호 2006/07/14 135
Admin  dgmgrl 운영, db11st h/w 교체 시나리오    최길호 2023/12/01 5
Admin  DGMGRL> show configuration; Error: ORA-16810: multiple errors or warnings detected for the database    최길호 2023/12/01 2
Admin  11gR2 ( 11.2.0.2 11.2.0.3 11.2.0.4 ) install download url    최길호 2023/11/30 6
Admin  /arch filesystem 100% full    최길호 2023/11/23 8
Admin  joez_shm_open_object failed    최길호 2023/11/17 4
Admin  Instance Critical Process (pid: 5, ospid: 131883, IPC0) died unexpectedly    최길호 2023/11/11 7
Admin  연속된 seq 값중 끊어진 값 확인 / with , connect by , minus    최길호 2023/11/10 8
Admin  WHENEVER SQLERROR EXIT FAILURE; / 에러 발생시 다시 시도 / sql retry    최길호 2023/11/09 13
Admin  DBV-00201: Block, DBA 20972580, marked corrupt for invalid redo application / ORA-01578 ORA-26040    최길호 2023/11/08 7
Admin  ORA-01124: cannot recover data file 1 - file is in use or recovery    최길호 2023/11/08 4
Troubleshoot  ORA-16047: DGID mismatch between destination setting and target database    최길호 2023/11/06 15

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

Copyright 1999-2023 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 최길호
최근 게시물
12/01
[ORACLE]
dgmgrl 운영, db11st h/w 교체 시나리....
by 최길호
12/01
[ORACLE]
DGMGRL> show configuration;....
by 최길호
11/23
[운영체제]
arch filesystem 100% full 예방 /....
by 최길호