Oracle Error ORA-24073: cannot specify RETENTION_TIME on exception queue string.string

Oracle Error Message

ORA-24073: cannot specify RETENTION_TIME on exception queue string.string

Reason for the Error

An attempt was made to create or alter an exception queue by specifying a non-zero RETENTION_TIME.

Solution

Use the default RETENTION_TIME parameter value for exception queues.