Deactivates an active index or indexes for databases enabled for multi-tenancy or table partitioning.

Syntax

proutil db-name -C idxdeactivate 
     { table [owner-name.]table-name |
         index [owner-name.]table-name.index-name}
              [ tenant tenant-name| group group-name |
                     partition partition-name| composite initial ]

Parameters

db-name

Specifies the database containing the index or indexes being deactivated.

table [owner-name.]table-name

Specifies the table of the index or indexes being deactivated. Specify the owner name if tables in your database have more than one owner.

index [owner-name.]table-name.index-name

Specifies the index being deactivated. Specify the owner name if tables in your database have more than one owner.

tenant tenant-name

Specifies that the IDXDEACTIVATE operation is to be performed only on the index partitions of tenant-name. If tenant-name does not own any partition of the specified indexes, IDXDEACTIVATE exits with an error. Specifying tenant is only allowed on databases enabled for multi-tenancy.

group group-name

Specifies that the IDXDEACTIVATE operation is to be performed only on the index partitions of group-name. If group-name does not own any partition of the specified indexes, IDXDEACTIVATE exits with an error. Specifying group is only allowed on databases enabled for multi-tenancy.

partition partition-name

Specifies that the IDXDEACTIVATE operation is to be performed only on the partition partition-name. If the partition named partition-name does not exist for the specified table, or the index specified is not a local index, IDXDEACTIVATE exits with an error. Specifying partition is only allowed on databases enabled for table partitioning.

composite initial

Specifies that the IDXDEACTIVATE operation is to be performed only on the composite initial partition. If the composite initial partition does not exist for the specified table, or the index specified is not a local index, IDXDEACTIVATE exits with an error. Specifying composite initial is only allowed on databases enabled for table partitioning.

IDXDEACTIVATE deactivates single or multiple indexes.

For multi-tenant tables:

• If you specify a table with the table parameter, you must specify a tenant or group, and all indexes of the tenant or group, except the primary index, are deactivated.
• If you specify an index with the index parameter, you must specify a tenant or group, and only that specific index partition is deactivated.

For table-partitioned tables:

• If you specify a table with the table parameter, you must specify a named partition or the composite initial partition. All local indexes of the partition, except the primary index, are deactivated.
• If you specify an index with the index parameter, and you specify a named partition or the composite initial partition, the index must be a local index, and only that specific index partition is deactivated.
• If you specify and index with the index parameter, and you do not specify a named partition or the composite initial partition, the index must be a global index, and that specific index is deactivated.

Notes

• IDXDEACTIVATE works for both online and offline databases.