My Oracle Support Banner

RDBPROD: Alter Index Rebuild Does Not Work After Maint Is Disabled. (Doc ID 423199.1)

Last updated on JANUARY 03, 2017

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.1 and later
HP OpenVMS Alpha
HP OpenVMS Itanium



Goal

The database has a large partitioned index and it is desired to perform extensive maintenance on its underlying table without updating the index until the end. It is desired to rebuild the index partitions in multiple jobs running in parallel. However, doing:

SQL> ALTER INDEX indexname MAINTENANCE IS DISABLED;

Then doing the work on the table and:

SQL> ALTER INDEX indexname REBUILD PARTITION partitionname;

Returns:

%RDB-E-NO_META_UPDATE, metadata update failed
-RDMS-E-INDMAINTDIS, maintenance on index indexname has been disabled

How is this accomplished?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.