Oracle Error ORA-25189: illegal ALTER TABLE option for an index-organized table

Oracle 33 Views 0 Min Read

Oracle Error Message

ORA-25189: illegal ALTER TABLE option for an index-organized table

Reason for the Error

During ALTER of a index-organized table, the user attempted to enter one or more of the following options: TABLESPACE, ALLOCATE/DEALLOCATE EXTENT, PCTFREE/PCTUSED for IOT top index segment

Solution

Remove the illegal option(s).

Tags: