A.13.15 OPG_APIS.CREATE_PG_TEXTIDX_TAB
Format
OPG_APIS.CREATE_PG_TEXTIDX_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_TEXTIDX_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 text index schema table (<graph_name>IT$) that stores data for managing text index metadata 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 index metadata 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 index metadata table has the following structure, which may change between releases.
( EIN nvarchar2(80) not null, -- index name ET number, -- entity type 1 - vertex, 2 -edge IT number, -- index type 1 - auto 0 - manual SE number, -- search engine 1 -solr, 0 - lucene K nvarchar2(3100), -- property key use an empty space when there is no K/V DT number, -- directory type 1 - MMAP, 2 - FS, 3 - JDBC LOC nvarchar2(3100), -- directory location (1, 2) NUMDIRS number, -- property key used to index CAN BE NULL VERSION nvarchar2(100), -- lucene version USEDT number, -- user data type (1 or 0) STOREF number, -- store fields into lucene CF nvarchar2(3100), -- configuration name SS nvarchar2(3100), -- solr server url SA nvarchar2(3100), -- solr server admin url ZT number, -- zookeeper timeout SH number, -- number of shards RF number, -- replication factor MS number, -- maximum shards per node PO nvarchar2(3100), -- preferred owner oracle text DS nvarchar2(3100), -- datastore FIL nvarchar2(3100), -- filter STR nvarchar2(3100), -- storage WL nvarchar2(3100), -- word list SL nvarchar2(3100), -- stop list LXR nvarchar2(3100), -- lexer OPTS nvarchar2(3100), -- options primary key (EIN, K, ET) )
By default, all schema tables will be created with basic compression enabled.
Examples
The following example creates a property graph text index metadata 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_TEXTIDX_TAB('mypg', 4, 'my_ts');
Parent topic: OPG_APIS Package Subprograms