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.
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.