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 RDF 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 RDF network. (See Table 1-2.)

network_name

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

Usage Notes

You must use this procedure to migrate RDF 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 RDF data that is already in the current format. It updates the definition of RDF 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 RDF 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 RDF 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');