SEM_APIS.RESTORE_SEM_NETWORK

Format

SEM_APIS.RESTORE_SEM_NETWORK_DATA(
     from_schema    DBMS_ID,
     degree         INTEGER DEFAULT NULL,
     options        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.RESTORE_RDF_NETWORK_DATA subprogram instead.

Description

Restores moved semantic network data from a staging schema back into a source semantic network.

Parameters

from_schema

The staging schema that contains moved semantic network data to be restored.

degree

Degree of parallelism to use for any SQL insert or index building operations. The default is no parallel execution.

options

String specifying any options to use during the append operation. Supported options are:

PURGE=T – drop all remaining semantic network data in the staging schema after the append operation completes.

network_owner

Owner of the destination semantic network for the restore operation. (See Table 1-2.)

network_name

Name of the destination semantic network for the restore operation. (See Table 1-2.)

Usage Notes

Partition exchange operations rather than SQL INSERT statements are used to move most of the data during the append operation, so the staging schema will no longer contain complete semantic network data after the restore operation is complete.

Moved semantic network data can only be restored into the original source semantic network from which it was moved.

You must have DBA privileges to call this procedure.

For more information, see Moving, Restoring, and Appending an RDF Network.

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

Examples

The following example restores a semantic network from the RDFEXPIMPU staging schema into the MYNET semantic network owned by RDFADMIN.

EXECUTE sem_apis.restore_sem_network_data(from_schema=>'RDFEXPIMPU',network_owner=>'RDFADMIN',network_name=>'MYNET');