Storage: Attributes

I_Index_Clause: Parameter clause for dr$<indexname>$X index creation. Specify storage and tablespace clauses to add to the end of the CREATE TABLE statement.

I_Table_Clause: Parameter clause for dr$<indexname>$I table creation. Specify storage and tablespace clauses to add to the end of the CREATE TABLE statement. The I table is the index data table.

K_Table_Clause: Parameter clause for dr$<indexname>$K table creation. Specify storage and tablespace clauses to add to the end of the CREATE TABLE statement. The K table is the keymap table.

N_Table_Clause: Parameter clause for dr$<indexname>$N table creation. Specify storage and tablespace clauses to add to the end of the CREATE TABLE statement. The N table is the negative list table.

P_Table_Clause: Parameter clause for dr$<indexname>$P table creation (created if Substring_Index = YES in the word list). Specify storage and tablespace clauses to add to the end of the CREATE TABLE statement. The P table is the pattern table, which stores rotations of all unique words in the main index table. Using the pattern table instead of the main index table allows wildcard searches (sometimes called left-truncated searches) to be processed more quickly.

R_Table_Clause: Parameter clause for dr$<indexname>$R table creation. Specify storage and tablespace clauses to add to the end of the CREATE TABLE statement. The R table is the rowid table.

Examples: The following SQL statements (displayed using the Show SQL button) include parameter clauses specifying that the index tables are to be created in the myspace tablespace with an initial extent of 1K:

begin

ctx_ddl.create_preference('mystore', 'BASIC_STORAGE');

ctx_ddl.set_attribute('mystore', 'I_TABLE_CLAUSE',

'tablespace myspace storage (initial 1K)');

ctx_ddl.set_attribute('mystore', 'K_TABLE_CLAUSE',

'tablespace myspace storage (initial 1K)');

ctx_ddl.set_attribute('mystore', 'R_TABLE_CLAUSE',

'tablespace myspace storage (initial 1K)');

ctx_ddl.set_attribute('mystore', 'N_TABLE_CLAUSE',

'tablespace myspace storage (initial 1K)');

ctx_ddl.set_attribute('mystore', 'I_INDEX_CLAUSE',

'tablespace myspace storage (initial 1K)');

end;

Buttons (Apply, Revert, Show SQL/Hide SQL)

See also: Main topics (outline)