7.9 SDO_NFE.DELETE_MODEL_STRUCTURE

Format

SDO_NFE.DELETE_MODEL_STRUCTURE(
     model_id  IN NUMBER);

Description

Drops all tables in a specified NFE model, and deletes the metadata records for the model.

Parameters

model_id

ID of the NFE model.

Usage Notes

Before using this procedure, you may need to do the following:

• Delete model’s workspaces by executing the SDO_NFE.DELETE_ALL_WORKSPACES procedure.

• Delete the model’s feature layers by executing the SDO_NFE.DELETE_ALL_FT_LAYERS procedure.

• If f the model’s edition mode is SDO_NFE.FROM_SCRATCH, delete the underlying network.

Examples

The following example the structure of the model with the ID value 1.

EXECUTE SDO_NFE.DELETE_MODEL_STRUCTURE(1);