9.14 OPG_APIS.CREATE_PG_SNAPSHOT_TAB
Format
OPG_APIS.CREATE_PG_SNAPSHOT_TAB( graph_owner IN VARCHAR2, graph_name IN VARCHAR2, dop IN INTEGER DEFAULT NULL, tbs IN VARCHAR2 DEFAULT NULL, options IN VARCHAR2 DEFAULT NULL);
or
OPG_APIS.CREATE_PG_SNAPSHOT_TAB( graph_name IN VARCHAR2, dop IN INTEGER DEFAULT NULL, tbs IN VARCHAR2 DEFAULT NULL, options IN VARCHAR2 DEFAULT NULL);
Description
Creates, for a given property graph name, the necessary property graph schema table (<graph_name>SS$) that stores data about snapshots for the graph.
Parameters
- graph_owner
-
Name of the owner of the property graph.
- graph_name
-
Name of the property graph.
- dop
-
Degree of parallelism for the operation.
- tbs
-
Name of the tablespace to hold all the graph snapshot data and associated index.
- options
-
Additional settings for the operation:
-
'INMEMORY=T' is an option for creating the schema tables with an 'inmemory' clause.
-
'IMC_MC_B=T' creates the schema tables with an INMEMORY MEMCOMPRESS BASIC clause.
-
Usage Notes
You must have the CREATE TABLE privilege to call this procedure.
The created snapshot table has the following structure, which may change between releases.
Name Null? Type ----------------------------------------- -------- ---------------------------- SSID NOT NULL NUMBER CONTENTS BLOB SS_FILE BINARY FILE LOB TS TIMESTAMP(6) WITH TIME ZONE SS_COMMENT VARCHAR2(512)
By default, all schema tables will be created with basic compression enabled.
Examples
The following example creates a snapshot table for property graph mypg
in the current schema, with a degree of parallelism of 4 and using the MY_TS tablespace.
EXECUTE OPG_APIS.CREATE_PG_SNAPSHOT_TAB('mypg', 4, 'my_ts');
Parent topic: OPG_APIS Package Subprograms