My Oracle Support Banner

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

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]
Information in this document applies to any platform.
***Checked for relevance on 28-Jun-2011***


Details

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

Actions

 

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:

Note:
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:

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.

Contacts

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
Details
Actions
Contacts

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