How to fix the Oracle error ORA-16226: DDL skipped due to lack of support?

In this post, you’ll learn more about the Oracle ErrorORA-16226: DDL skipped due to lack of support with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-16226: DDL skipped due to lack of support

Reason for the Error ORA-16226: DDL skipped due to lack of support

Logical Standby does not support this type of DDL in this version, so the DDL is skipped.

How to fix the Error ORA-16226: DDL skipped due to lack of support ?

You can fix this error in Oracle by following the below steps

The DBA may apply the DDL explicitly at a later time or a procedure to handle this type of DDL can be created. see DBMS_LOGSTDBY.SKIP procedure for details.