16.4.1.9 Replication of DROP ... IF EXISTS Statements
The DROP DATABASE
IF EXISTS, DROP TABLE IF
EXISTS, and DROP VIEW IF
EXISTS statements are always replicated, even if the database, table, or view to be dropped does not exist on the source. This is to ensure that the object to be dropped no longer exists on either the source or the replica, once the replica has caught up with the source.
DROP ... IF EXISTS statements for stored programs (stored procedures and functions, triggers, and events) are also replicated, even if the stored program to be dropped does not exist on the source.
© 2025 Oracle
Licensed under the GPLv2 License.