Expand To Show Full Article
Oracle Error ORA-16247: DDL skipped on internal schema - Developer Publish

Oracle Error ORA-16247: DDL skipped on internal schema

Oracle Error Message

ORA-16247: DDL skipped on internal schema

Reason for the Error

Logical Standby ignores DDLs on internal schemas such as SYS and SYSTEM. For a complete list of internal schemas ignored by Logical Standby perform the following query: SELECT owner FROM dba_logstdby_skip WHERE statement_opt = ‘INTERNAL SCHEMA’.

Solution

No action necessary, this informational statement is provided to record the event for diagnostic purposes.