Menu
Amazon Relational Database Service
User Guide (API Version 2014-10-31)

Oracle Spatial

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. For more information, see Spatial Concepts in the Oracle documentation.

Important

If you use Oracle Spatial, Amazon RDS automatically updates your DB instance to the latest Oracle PSU if there are security vulnerabilities with a Common Vulnerability Scoring System (CVSS) score of 9+ or other announced security vulnerabilities.

Amazon RDS supports Oracle Spatial for the following editions and versions of Oracle:

  • Oracle Enterprise Edition, version 12.1.0.2.v6 or later

  • Oracle Enterprise Edition, version 11.2.0.4.v10 or later

Prerequisites for Oracle Spatial

The following are prerequisites for using Oracle Spatial:

  • An Amazon RDS DB instance that's running Oracle Enterprise Edition version 12.1.0.2.v6 or later, or 11.2.0.4.v10 or later.

  • Your DB instance must be inside a virtual private cloud (VPC). For more information, see Determining Whether You Are Using the EC2-VPC or EC2-Classic Platform.

  • Your DB instance must be of sufficient class. Oracle Spatial is not supported for the db.m1.small, db.t1.micro, db.t2.micro, or db.t2.small DB instance classes. For more information, see DB Instance Class Support for Oracle.

  • Your DB instance must have Auto Minor Version Upgrade enabled. Amazon RDS updates your DB instance to the latest Oracle PSU if there are security vulnerabilities with a CVSS score of 9+ or other announced security vulnerabilities. For more information, see Settings for Oracle DB Instances.

  • If your DB instance is version 11.2.0.4.v10 or later, you must install the XMLDB option. For more information, see Oracle XML DB.

  • An Oracle Spatial license from Oracle. For more information, see Oracle Spatial and Graph in the Oracle documentation.

Best Practices for Oracle Spatial

The following are best practices for using Oracle Spatial:

Adding the Oracle Spatial Option

The following is the general process for adding the SPATIAL option to a DB instance:

  1. Create a new option group, or copy or modify an existing option group.

  2. Add the option to the option group.

  3. Associate the option group with the DB instance.

There is a brief outage while the SPATIAL option is added. After you add the option, you don't need to restart your DB instance. As soon as the option group is active, Oracle Spatial is available.

To add the SPATIAL option to a DB instance

  1. Determine the option group that you want to use. You can create a new option group or use an existing option group. If you want to use an existing option group, skip to the next step. Otherwise, create a custom DB option group with the following settings:

    1. For Engine, choose oracle-ee.

    2. For Major Engine Version, choose 11.2 or 12.1 for your DB instance.

    For more information, see Creating an Option Group.

  2. Add the SPATIAL option to the option group. For more information about adding options, see Adding an Option to an Option Group.

  3. Apply the option group to a new or existing DB instance:

Removing the Oracle Spatial Option

You can remove the SPATIAL option from a DB instance. There is a brief outage while the option is removed. After you remove the SPATIAL option, you don't need to restart your DB instance.

To remove the SPATIAL option from a DB instance, do one of the following:

  • Remove the SPATIAL option from the option group it belongs to. This change affects all DB instances that use the option group. For more information, see Removing an Option from an Option Group.

  • Modify the DB instance and specify a different option group that doesn't include the SPATIAL option. This change affects a single DB instance. You can specify the default (empty) option group, or a different custom option group. For more information, see Modifying a DB Instance Running the Oracle Database Engine.

Related Topics