SEM_APIS.APPEND_SEM_NETWORK_DATA

Format

SEM_APIS.APPEND_SEM_NETWORK_DATA(
     from_schema    IN DBMS_ID,
     degree         IN INTEGER DEFAULT NULL,
     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.APPEND_RDF_NETWORK_DATA subprogram instead.

Description

Appends moved semantic network data from a staging schema into a semantic network.

Parameters

from_schema

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

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 append operation. (See Table: network_owner and network_name Parameters.)

network_name

Name of the destination semantic network for the append operation. (See Table: network_owner and network_name Parameters.)

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 operation is complete.

You must have DBA privileges to call this procedure.

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

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

Examples

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

EXECUTE sem_apis.append_sem_network_data(from_schema=>'RDFEXPIMPU',network_owner=>'RDFADMIN',network_name=>'MYNET'):