15.78 SEM_APIS.DROP_SPM_TAB

Format

SEM_APIS.DROP_SPM_TAB (
     spm_type           IN NUMBER,
     spm_name           IN VARCHAR2,
     model_name         IN VARCHAR2,
     options            IN VARCHAR2 DEFAULT NULL,
     network_owner      IN DBMS_ID 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.DROP_RESULT_TAB subprogram instead.

Description

Drops SPM table(s) defined on a given RDF model.

Parameters

spm_type

Type of the SPM table.

The value can be one of the following:

• SEM_APIS.SPM_TYPE_SVP
• SEM_APIS.SPM_TYPE_MVP
• SEM_APIS.SPM_TYPE_PCN
• SEM_APIS.SPM_TYPE_ALL

  Use of SEM_APIS.SPM_TYPE_ALL indicates that the target SPM tables can be of any type.

spm_name

String for use as part of the name of the SPM table. If the target is an MVP table, then specify the name of the property. Use of the value ‘*’ indicates that the target is the set of all the SPM tables of the type specified by the spm_type parameter.

model_name

Name of the RDF model.

options

Reserved for future use.

network_owner

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

network_name

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

Usage Notes

• This operation has a DDL semantics.
• The invoker must be the owner of the target RDF model or the RDF network or both.

Examples

The following example drops a specific SVP table named FLHF:

BEGIN
  SEM_APIS.DROP_SPM_TAB(
     spm_type      => SEM_APIS.SPM_TYPE_SVP
   , spm_name      => 'FLHF'
   , model_name    => 'M1'
   , network_owner => 'RDFUSER'
   , network_name  => 'NET1'
  );
END;
/

The following example drops all the currently existing SPM tables on model M1:

BEGIN
  SEM_APIS.DROP_SPM_TAB(
     spm_type      => SEM_APIS.SPM_TYPE_ALL
   , spm_name      => '*'
   , model_name    => 'M1'
   , network_owner => 'RDFUSER'
   , network_name  => 'NET1'
  );
END;
/