Oracle Spatial on RDS

Hi Jin,

Amazon RDS supports Oracle Spatial through the use of the SPATIAL option. Oracle Spatial provides a SQL schema and functions that facilitate the storage, retrieval, update, and query of collections of spatial data in an Oracle database. One thing to note is that If you use Oracle Spatial, Amazon RDS automatically updates your DB instance to the latest Oracle PSU when any of the following exist:

• Security vulnerabilities with a Common Vulnerability Scoring System (CVSS) score of 9+
• Other announced security vulnerabilities

Regarding the engine versions, Amazon RDS supports Oracle Spatial only in Oracle Enterprise Edition (EE) and Oracle Standard Edition 2 (SE2) for 19c and 21c DB versions. You can obtain more details in the link below.

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Oracle.Options.Spatial.html

The following are best practices for using Oracle Spatial:

For maximum security, use the SPATIAL option with Secure Sockets Layer (SSL). For more information, see Oracle Secure Sockets Layer. [https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_VPC.Scenarios.html]

• Configure your DB instance to restrict access to your DB instance. For more information, see Scenarios for accessing a DB instance in a VPC [https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_VPC.Scenarios.html]

Hope it helps and if it does, I would appreciate if answer can be accepted so that community can benefit for clarity when searching for similar enquirers in Repost, thank you.