当前位置:网站首页>Oracle配置st_geometry
Oracle配置st_geometry
2022-04-23 19:08:00 【Gis烤羊腿真好吃】
Oracle配置st_geometry
1 拷贝st_shapelib.dll 文件 到 oracle数据库的安装目录:D:\app\Administrator\product\11.2.0\dbhome_1\BIN ;
2 修改Oracle两个监听文件,分别为:
extporc.ora ( 路径为D:\app\Administrator\product\11.2.0\dbhome_1\hs\admin ) 和
listener.ora (路径为:D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN );
3 重启oracle数据库的服务监听;
4 使用PL/SQL登录数据库,依次执行以下语句即可:
(1)create or replace library ST_SHAPELIB as ‘D:\app\Administrator\product\11.2.0\dbhome_1\BIN\st_shapelib.dll’; 此路径即第一步骤所讲的;
(2)alter package sde.st_geometry_shapelib_pkg compile reuse settings ;
5 在执行完上述两个语句之后,即可验证是否配置成功:
执行语句:select sde.st_AsText(SDE.ST_Geometry(‘POINT(10,10)’, 0)) from dual; 成功返回结果,即配置成功!
版权声明
本文为[Gis烤羊腿真好吃]所创,转载请带上原文链接,感谢
https://blog.csdn.net/weixin_38190600/article/details/102467201
边栏推荐
- Codeforces Round #784 (Div. 4)
- Raspberry pie 18b20 temperature
- [advanced level 11 of C language -- character and string functions and their simulation implementation (2)]
- Using Visual Studio code to develop Arduino
- Actual combat of Nacos as service configuration center
- Use of content provider
- Using bafayun to control the computer
- MySQL Téléchargement et installation de la version Linux
- Scrollto and scrollby
- 机器学习理论基础篇--关于机器学习的一些术语
猜你喜欢
Switching power supply design sharing and power supply design skills diagram
Eight bit binary multiplier VHDL
Esp32 (UART event) - serial port event learning (1)
Esp32 (UART receiving and sending) - receiving and sending communication of serial port (4)
[advanced level 11 of C language -- character and string functions and their simulation implementation (2)]
FTP、ssh远程访问及控制
PyGame tank battle
Installation, use and problem summary of binlog2sql tool
2022.04.23(LC_763_划分字母区间)
从技术体系到商业洞察,中小研发团队架构实践之收尾篇
随机推荐
Sogou cell thesaurus analysis (only extract words and word frequency)
Yyds dry goods inventory stringprep --- Internet string preparation
C1000k TCP connection upper limit test 1
网络协议之:sctp流控制传输协议
[today in history] April 23: the first video uploaded on YouTube; Netease cloud music officially launched; The inventor of digital audio player was born
c1000k TCP 连接上限测试1
Using 8266 as serial port debugging tool
Esp01s with Arduino development environment
SSDB基础1
The difference between ordinary inner class and static inner class
c#:泛型反射
Go language GUI framework Fyne Chinese garbled or not displayed
Disable Ctrl + Alt + Del
Tencent map and high logo removal method
FTP、ssh远程访问及控制
ESP32 LVGL8. 1 - msgbox message box (msgbox 28)
How can programmers quickly develop high-quality code?
8266 obtain 18b20 temperature
Coolweather is revised and connected to the wind weather interface to realize the broken line diagram of temperature
Some records used by VS2010