When a User Specifies Only an Index Name to Modify the Index, A Message Indicating That the Index Does Not Exist Is Displayed

-- Create a partitioned table index HR_staffS_p1_index1, without specifying index partitions.
CREATE INDEX HR_staffS_p1_index1 ON HR.staffS_p1 (staff_ID) LOCAL;
-- Create a partitioned table index HR_staffS_p1_index2, with index partitions specified.
CREATE INDEX HR_staffS_p1_index2 ON HR.staffS_p1 (staff_ID) LOCAL
(
PARTITION staff_ID1_index,
PARTITION staff_ID2_index TABLESPACE example3,
PARTITION staff_ID3_index TABLESPACE example4
) TABLESPACE example;
-- Change the tablespace of index partition staff_ID2_index to example1. A message is displayed, indicating that the index does not exist.
ALTER INDEX HR_staffS_p1_index2 MOVE PARTITION staff_ID2_index TABLESPACE example1;

-- Run the following command to validate the inference. It is found that the calling is successful.
ALTER INDEX hr.HR_staffS_p1_index2 MOVE PARTITION staff_ID2_index TABLESPACE example1;
-- Change the schema of the current session to hr.
ALTER SESSION SET CURRENT_SCHEMA TO hr;
-- Run the following command to modify the index:
ALTER INDEX HR_staffS_p1_index2 MOVE PARTITION staff_ID2_index TABLESPACE example1;

schema.table