Required Procedure for Semantic Technologies Support in 11gR1
(Doc ID 452989.1)
Last updated on AUGUST 24, 2021
Applies to:Oracle Spatial and Graph - Version 18.104.22.168 to 22.214.171.124 [Release 11.1]
Information in this document applies to any platform.
***Checked for relevance on 28-Jun-2011***
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';
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