ORA-14194: only one subpartition may be rebuilt
Cause: ALTER INDEX REBUILD SUBPARTITION contained descriptions of more than one subpartition to be rebuilt
Action: Ensure that the statement describes exactly one subpartition to be rebuilt and that it does not contain any commas
ORA-14194 is an Oracle Database error code indicating that only one subpartition may be rebuilt at a time.
The official explanation of this error is “ORA-14194: only one subpartition may be rebuilt”.
Common cases in which this error may be encountered include attempting to rebuild more than one subpartition at a time while using an ALTER TABLE MODIFY command, or attempting to rebuild more than one subpartition at once while using the ALTER TABLE ADD PARTITION command.
In order to resolve this error, an ALTER TABLE statement should be issued in order to specify that just one subpartition is the target of the rebuild. The syntax is as follows:
ALTER TABLE table_name { MODIFY PARTITION partition_name REBUILD SUBPARTITION subpartition_name | ADD PARTITION partition_name REBUILD SUBPARTITION subpartition_name }
Once the one subpartition has been specified, the rebuild can be completed successfully.