ORA-14416: Online DDL's cannot be used with certain types of tables.

ORA-14416: Online DDL's cannot be used with certain types of tables.


Cause:


An attempt was made to use the DROP INDEX ONLINE, ALTER TABLE DROP CONSTRAINT ONLINE, or ALTER TABLE SET UNUSED COLUMN ONLINE statement on an table type (for example, cluster, temporary, index-organized table (IOT), external tables) that was not allowed.



Action:


Using online DDL's like DROP INDEX ONLINE, ALTER TABLE DROP CONSTRAINT ONLINE, or ALTER TABLE SET UNUSED COLUMN ONLINE statement on certain types of tables (for example, cluster, temporary, indexed-organized table (IOT), external tables) is illegal. Remove the ONLINE keyword from the statement.