当前位置：网站首页>Oracle configuration st_ geometry

Oracle configuration st_ geometry

2022-04-23 19:08:00 【GIS roast lamb leg is delicious】

Oracle To configure st_geometry

1 Copy st_shapelib.dll file To oracle Database installation directory ：D:\app\Administrator\product\11.2.0\dbhome_1\BIN ;
2 modify Oracle Two listening files , Respectively ：
extporc.ora （ Path is D:\app\Administrator\product\11.2.0\dbhome_1\hs\admin ） and
listener.ora （ Path is ：D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN ）;
　 Insert picture description here Insert picture description here
3 restart oracle Service monitoring of database ;
4 Use PL/SQL Log in to the database , Execute the following statements in sequence ：
（1）create or replace library ST_SHAPELIB as ‘D:\app\Administrator\product\11.2.0\dbhome_1\BIN\st_shapelib.dll’; This path is the first step ;
（2）alter package sde.st_geometry_shapelib_pkg compile reuse settings ;
5 After executing the above two statements , To verify whether the configuration is successful ：
　　 Execute statement ：select sde.st_AsText(SDE.ST_Geometry(‘POINT(10,10)’, 0)) from dual; Successfully returned results , The configuration is successful ！

版权声明
本文为[GIS roast lamb leg is delicious]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204231908121061.html

边栏推荐

猜你喜欢

随机推荐