ORA-00001: UNIQUE CONSTRAINT (USER.SYS_IOT_TOP_XXXXXX) VIOLATED W/ DYNAMIC ENQUEUE/DEQUEUE AND ADD/REMOVE SUBSCRIBERS (Doc ID 2884939.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 19.8.0.0.0 and later
Information in this document applies to any platform.

Symptoms

If you see Q00 processes running into ORA-00001 error when the patch for bug 33174861 is applied, this is the bug you're likely hitting

Bug 34020905 - ORA-00001: UNIQUE CONSTRAINT (USER.SYS_IOT_TOP_XXXX) VIOLATED W/ DYNAMIC ENQUEUE/DEQUEUE AND ADD/REMOVE SUBSCRIBERS

Changes

If you see Q00 processes running into ORA-00001 error when the patch for bug 33174861 is applied, this is the bug 34020905 you're likely hitting

Cause

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.