15.15 SEM_APIS.ALTER_SEM_INDEXES

Format

SEM_APIS.ALTER_SEM_INDEXES(
     attr_name  IN VARCHAR2,
     new_val    IN VARCHAR2,
     options    IN VARCHAR2 DEFAULT NULL,
     network_owner   IN VARCHAR2 DEFAULT NULL,
     network_name    IN VARCHAR2 DEFAULT NULL);

Note:

This subprogram will be deprecated in a future release. It is recommended that you use the SEM_APIS.ALTER_RDF_INDEXES subprogram instead.

Description

Alters an attribute of all indexes on RDF_VALUE$ and RDF_LINK$ tables.

Parameters

attr_name

Attribute to be altered..

new_val

New value for the attribute.

options

(Not currently used.)

network_owner

Owner of the semantic network. (See Table 1-2.)

network_name

Name of the semantic network. (See Table 1-2.)

Usage Notes

You must have DBA privileges to call this procedure.

Currently, the only attr_name value supported is VISIBILITY, and the only new_val values supported are Y (visible indexes) and N (invisible indexes).

For an explanation of semantic network indexes, see Using Semantic Network Indexes, including the subtopic about using invisible indexes.

For information about semantic network types and options, see RDF Networks.

Examples

The following example makes all semantic network indexes invisible.

EXECUTE SEM_APIS.ALTER_SEM_INDEXES(‘VISIBILITY’, 'N');