A Enabling, Downgrading, or Removing RDF Graph Support

You must perform certain steps before you can use any types, synonyms, or PL/SQL packages related to RDF Graph support in the current Oracle Database release.

You must run one or more scripts, and you must ensure that Oracle Spatial is installed and the Partitioning option is enabled. These requirements are explained in Enabling RDF Graph Support and its related subtopics.

This appendix also describes the steps if, after enabling RDF Graph support, you need to do any of the following:

• Downgrade the RDF Graph support to that provided with a previous Oracle Database release, as explained in Downgrading RDF Graph Support to a Previous Release.

• Remove all support for RDF Graph from the database, as explained in Removing RDF Graph Support.

• Enabling RDF Graph Support
  Before you can use any types, synonyms, or PL/SQL packages related to RDF Graph support in the current Oracle Database release, you must either install the capabilities in a new Oracle Database installation or upgrade the capabilities from a previous release.
• Downgrading RDF Graph Support to a Previous Release
  You can downgrade the RDF Graph support, in conjunction with an Oracle Database downgrade to Release 12.1.
• Removing RDF Graph Support
  You can remove the RDF Graph support from the database.

A.1 Removing RDF Graph Support

You can remove the RDF Graph support from the database.

However, removing this support is strongly discouraged, unless you have a solid reason for doing it. After you remove this support, no applications or database users will be able to use any types, synonyms, or PL/SQL packages related to RDF Graph support.

To remove the RDF Graph support from the database, perform the following steps:

1. Connect to the database as the SYS user with SYSDBA privileges (SYS AS SYSDBA, and enter the SYS account password when prompted).

2. Start SQL*Plus, and enter the following statement:

   • Linux: @$ORACLE_HOME/md/admin/semremov.sql

   • Windows: @%ORACLE_HOME%\md\admin\semremov.sql

   Note:

   If you are in a multitenant environment, run the script with catcon.pl. See “Running Oracle-Supplied SQL Scripts in a CDB” in Oracle Database Administrator’s Guide.

The semremov.sql script drops the semantic network and removes any RDF Graph types, tables, and PL/SQL packages.