A.13.13 OPG_APIS.CREATE_PG
Format
OPG_APIS.CREATE_PG( graph_name IN VARCHAR2, dop IN INTEGER DEFAULT NULL, num_hash_ptns IN INTEGER DEFAULT 8, tbs IN VARCHAR2 DEFAULT NULL, options IN VARCHAR2 DEFAULT NULL);
Description
Creates, for a given property graph name, the necessary property graph schema tables that are necessary to store data about vertices, edges, text indexes, and snapshots.
Parameters
- graph_name
-
Name of the property graph.
- dop
-
Degree of parallelism for the operation.
- num_hash_ptns
-
Number of hash partitions used to partition the vertices and edges tables. It is recommended to use a power of 2 (2, 4, 8, 16, and so on).
- tbs
-
Name of the tablespace to hold all the graph data and index data.
- options
-
Options that can be used to customize the creation of indexes on schema tables. (One or more, comma separated.)
-
'SKIP_INDEX=T' skips the default index creation.
-
'SKIP_ERROR=T 'ignores errors encountered during table/index creation.
-
'INMEMORY=T' creqtes the schema tables with an INMEMORYclause.
-
'IMC_MC_B=T' creates the schema tables with an INMEMORY BASIC clause.
-
Usage Notes
You must have the CREATE TABLE and CREATE INDEX privileges to call this procedure.
By default, all the schema tables will be created with basic compression enabled.
Examples
The following example creates a property graph named mypg
in the tablespace my_ts
using eight partitions.
EXECUTE OPG_APIS.CREATE_PG('mypg', 4, 8, 'my_ts');
Parent topic: OPG_APIS Package Subprograms