RDBPROD: Alter Index Rebuild Does Not Work After Maint Is Disabled.
(Doc ID 423199.1)
Last updated on JANUARY 08, 2020
Applies to:
Oracle Rdb Server on OpenVMS - Version 7.1 and laterHP 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
-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! |
In this Document
Goal |
Solution |