6 OPG_GRAPHOP Package Subprograms

The OPG_GRAPHOP package contains subprograms for various operations on property graphs in an Oracle database.

To use the subprograms in this chapter, you must understand the conceptual and usage information in earlier chapters of this book.

This chapter provides reference information about the subprograms, in alphabetical order.

6.1 OPG_GRAPHOP.POPULATE_SKELETON_TAB

Format

OPG_GRAPHOP.POPULATE_SKELETON_TAB(
     graph    IN VARCHAR2,
     dop      IN INTEGER DEFAULT 4,
     tbs      IN VARCHAR2 DEFAULT NULL,
     options  IN VARCHAR2 DEFAULT NULL);

Description

Populates the skeleton table (<graph-name>GT$). By default, any existing content in the skeleton table is truncated (removed) before the table is populated.

Parameters

graph

Name of the property graph.

dop

Degree of parallelism for the operation.

tbs

Name of the tablespace to hold the index data for the skeleton table.

options

Options that can be used to customize the populating of the skeleton table. (One or more, comma separated.)

  • 'KEEP_DATA=T' causes any existing table not to be removed before the table is populated. New rows are added after the existing ones.

  • 'PDML=T' skips the default index creation.

Usage Notes

You must have the CREATE TABLE and CREATE INDEX privileges to call this procedure.

There is a unique index constraint on EID column of the skeleton table (GE$). So if you specify the KEEP_DATA=T option and if the new data overlaps with existing one, then the unique key constraint will be violated, resulting in an error.

Examples

The following example populates the skeleton table of the property graph named mypg.

EXECUTE OPG_GRAPHOP.POPULATE_SKELETON_TAB('mypg',4, 'pgts', 'PDML=T');