15.125 SEM_APIS.MIGRATE_DATA_TO_STORAGE_V2

Format

SEM_APIS.MIGRATE_DATA_TO_STORAGE_V2(
     options        IN VARCHAR2 DEFAULT NULL,
     network_owner  IN VARCHAR2 DEFAULT NULL,
     network_name   IN VARCHAR2 DEFAULT NULL); 

Description

Migrates semantic data from escaped storage form to unescaped storage form.

Parameters

options

If you specify PARALLEL=<n>, the migration is performed using the specified degree of parallelism. If you do not specify this option, then by default no parallel processing is 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

It is strongly recommended that you use unescaped storage form for your semantic network, because it reduces storage cost and improves query performance, while requiring no changes to your existing applications.

This procedure must be run as the network owner.

After executing this procedure, a row with the following column values should be present in the network’s RDF_PARAMETER table (described in RDF_PARAMETER Table in RDF Networks):

• Namespace: NETWORK
• Attribute: STORAGE_FORM
• Value: UNESC
• Description: Storage form setting for a semantic network.

See also Migrating from Escaped to Unescaped Storage Form.

Examples

The following example migrates a semantic network named NET1 owned by RDFUSER from escaped storage form to unescaped storage form. A degree of parallelism of 4 is used for the operation.

EXECUTE sem_apis.migrate_data_to_storage_v2(options=>' PARALLEL=4 ', network_owner=>'RDFUSER', network_name=>'NET1');

The following example migrates a semantic network named NET1 owned by RDFUSER from escaped storage form to unescaped storage form.

EXECUTE sem_apis.migrate_data_to_storage_v2(network_owner=>'RDFUSER', network_name=>'NET1');