BASIC_STORAGE

The BASIC_STORAGE indexing type specifies the tablespace and creation parameters for the database tables and indexes that constitute a Text index.

The clause you specify is added to the internal CREATE TABLE (CREATE INDEX for the i_index_clause) statement at index creation. You can specify most allowable clauses, such as storage, LOB storage, or partitioning. However, you cannot specify an index organized table clause.

You can store Text index tables in the In-Memory Column Store (IM column store) by specifying inmemory in the storage clause for that table. IM column store is supported for the types of tables represented by the following storage attributes: I_TABLE_CLAUSE, R_TABLE_CLAUSE, G_TABLE_CLAUSE, O_TABLE_CLAUSE, D_TABLE_CLAUSE, SN_TABLE_CLAUSE, and E_TABLE_CLAUSE.

This section contains the following topics.

• BASIC_STORAGE Attributes

• BASIC_STORAGE Default Behavior

• BASIC_STORAGE Examples

See Also:

• Oracle Database SQL Language Reference for more information about how to specify CREATE INDEX statement

• Oracle Database SQL Language Reference for more information about how to specify CREATE TABLE statement