My Oracle Support Banner

Required Procedure for Semantic Technologies Support in 11gR1 (Doc ID 452989.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Spatial and Graph - Version to [Release 11.1]
Information in this document applies to any platform.


It is necessary to run a script in order to use types, synonyms and PL/SQL packages related to Oracle Semantic Technologies.



Make sure that Oracle Text is installed and its status is VALID

conn / as sysdba
col comp_name format a30
col status format a10
select comp_name, status from dba_registry
where comp_name = 'Oracle Text';

COMP_NAME                      STATUS
------------------------------ ----------
Oracle Text                    VALID

If it is not installed, you can use the following note to install Oracle Text
Note 579601.1 - Manual installation, deinstallation and verification of Oracle Text 11gR1

Otherwise you may get error PLS-00201: identifier 'CTX_DDL.DROP_PREFERENCE' must be declared during the semantics setup

This is a reference from:

Oracle® Database Semantic Technologies Developer's Guide 11g Release 1 (11.1)
Chapter 1 Oracle Semantic Technologies Overview

1.10 Required Procedure for Semantic Technologies Support

Before you can use any types, synonyms, or PL/SQL packages related to Oracle semantic technologies support, you must connect to the database as a user with DBA privileges, start SQL*Plus, and execute one of the following scripts, depending on your needs:

  • Upgrade with data migration: $ORACLE_HOME/md/admin/catsem10i.sql
  • New installation: $ORACLE_HOME/md/admin/catsem11i.sql

If you are upgrading from Oracle Database Release 10.2 and have any Release 10.2 RDF data, and if you do not want the RDF data to be migrated, you must do the following before running the catsem10i.sql script:

  • Drop the RDF network.
  • Drop all columns of types SDO_RDF_TRIPLE_S and SDO_RDF_TRIPLE in user tables.

The catsem10i.sql script is comprehensive and handles both installation and (if necessary) any RDF data migration from Release 10.2 to Release 11 format. This script is required if you have an existing Release 10.2 RDF network; however, it may take a long time to run if the existing Release 10.2 RDF network contains large amount of RDF data.

The catsem11i.sql script is sufficient if you have a new Release 11.1 installation or if you are upgrading from Release 10.2 but do not have any existing RDF network and any columns of types SDO_RDF_TRIPLE_S or SDO_RDF_TRIPLE in user tables.

If a Release 10.2 RDF network exists or if dependencies exist on the Release 10.2 RDF types SDO_RDF_TRIPLE_S or SDO_RDF_TRIPLE, the catsem11i.sql script will exit with an error. In that case, you can continue using Release 10.2 RDF support and run the catsem10i.sql script later, when you are ready to upgrade.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.