In this post, you’ll learn more about the Oracle ErrorORA-24064: propagation for QUEUE string and DESTINATION string already enabled with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-24064: propagation for QUEUE string and DESTINATION string already enabled
Reason for the Error ORA-24064: propagation for QUEUE string and DESTINATION string already enabled
An ENABLE_SCHEDULE_PROPAGATION command was issued for a queue and destination pair whose propagation schedule already was enabled.
How to fix the Error ORA-24064: propagation for QUEUE string and DESTINATION string already enabled ?
You can fix this error in Oracle by following the below steps
Make sure the QUEUE and DESTINATION are correct when you issue the ENABLE_SCHEDULE_PROPAGATION command.