DB_INDEX_COMPRESSION_INHERITANCE

Property Description

Parameter type

String

Syntax

DB_INDEX_COMPRESSION_INHERITANCE = { TABLESPACE | TABLE | ALL | NONE }

Default value

NONE

Modifiable

ALTER SESSION, ALTER SYSTEM

Basic

No

Oracle RAC

You must set this parameter for every instance, and multiple instances must have the same value.

DB_INDEX_COMPRESSION_INHERITANCE displays the options that are set for table or tablespace level compression inheritance.

Values:

  • TABLESPACE

    Indexes will be created with ADVANCED LOW compression if the tablespace they reside in has OLTP compression enabled as the default.

  • TABLE

    If the underlying table is OLTP compressed, the indexes on this table will be ADVANCED LOW compressed.

  • ALL

    If either the underlying table or tablespace is OLTP compressed, the indexes on this table will be ADVANCED LOW compressed.

  • NONE

    Indexes will not inherit any compression from the base table or its tablespace. They will only be compressed if users specify it.

See Also:

Oracle Database Administrator's Guide for more information about index compression