A.13.16 OPG_APIS.CREATE_STAT_TABLE
Format
OPG_APIS.CREATE_STAT_TABLE( stattab IN VARCHAR2, tblspace IN VARCHAR2 DEFAULT NULL);
Description
Creates a table that can hold property graph statistics.
Parameters
Usage Notes
You must have the CREATE TABLE privilege to call this procedure.
The statistics table has the following columns. Note that the columns and their types may vary between releases.
Name Null? Type ----------------------------------------- -------- ---------------------------- STATID VARCHAR2(128) TYPE CHAR(1) VERSION NUMBER FLAGS NUMBER C1 VARCHAR2(128) C2 VARCHAR2(128) C3 VARCHAR2(128) C4 VARCHAR2(128) C5 VARCHAR2(128) C6 VARCHAR2(128) N1 NUMBER N2 NUMBER N3 NUMBER N4 NUMBER N5 NUMBER N6 NUMBER N7 NUMBER N8 NUMBER N9 NUMBER N10 NUMBER N11 NUMBER N12 NUMBER N13 NUMBER D1 DATE T1 TIMESTAMP(6) WITH TIME ZONE R1 RAW(1000) R2 RAW(1000) R3 RAW(1000) CH1 VARCHAR2(1000) CL1 CLOB
Examples
The following example creates a statistics table namedmystat
.
EXECUTE OPG_APIS.CREATE_STAT_TABLE('mystat',null);
Parent topic: OPG_APIS Package Subprograms