ORA-25182
Found ORA-25182 when I tried to move an index-organized table to another tablespace.
SQL> ALTER TABLE ERPAPP.CONFIG MOVE TABLESPACE ERP_TBS_01 ONLINE PARALLEL 16;
ALTER TABLE ERPAPP.CONFIG MOVE TABLESPACE ERP_TBS_01 ONLINE PARALLEL 16
*
ERROR at line 1:
ORA-25182: feature not currently available for index-organized tables
It seems that we can't move the index-organized table ONLINE as well as PARALLEL.
Let's see the restrictions about Restrictions on the ONLINE clause in Oracle 19c.
You cannot specify the ONLINE clause for index-organized tables.
Really? I thought IOT except partitioned ones is able to use ONLINE clause. In this case, the table is not a partitioned IOT.
However, I decided to remove ONLINE clause in the statement, then do it again.
SQL> ALTER TABLE ERPAPP.CONFIG MOVE TABLESPACE ERP_TBS_01 PARALLEL 16;
Table altered.
We solved ORA-25182.