SEM_APIS.MIGRATE_DATA_TO

Format

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

Description

Migrates semantic data from before Oracle Database Release 21c data format to the format needed for use with RDF in the current Oracle Database release.

Parameters

options: If you specify INS_AS_SEL=T, the migration is performed using a bulk load operation. If you do not specify that value, then by default update operations are performed. See the Usage Notes for more information.
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 use this procedure to migrate semantic data created using versions of Oracle Database earlier than Release 21c, as explained in Required Migration of Pre-12.2 RDF Data.

This procedure does not perform any operation on semantic data that is already in the current format. It updates the definition of semantic network triggers, views, and PL/SQL packages in the network owner’s schema.

For the options parameter, if the amount of data to be migrated is small, the default (not specifying the parameter) probably provides adequate performance. However, for large amounts of data, specifying INS_AS_SEL=T can improve performance significantly.

This procedure must be run as the network owner.

Examples

The following example migrates Release 19 semantic data in a network named NET1 and owned by RDFUSER to the format for the current Oracle Database version. It performs the migration using a bulk load operation.

EXECUTE sem_apis.migrate_data_to_current('INS_AS_SEL=T', network_owner=>'RDFUSER', network_name=>'NET1');

The following example migrates Release 19 semantic data in a network named NET1 and owned by RDFUSER to the format for the current Oracle Database version. It performs the migration using update operations (the default).

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