My Oracle Support Banner

Missing Streams Multi-Version Data Dictionary messages reported on Table creation when the tables have constraints defined (Doc ID 471858.1)

Last updated on FEBRUARY 01, 2022

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2]
Oracle Database - Enterprise Edition - Version to [Release 9.2]
Oracle Database - Enterprise Edition - Version to [Release 10.1]
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


'MISSING Streams multi-version data dictionary' messages reported once for non-replicated and replicated objects when Streams is initially setup.

The errors are reported when creating tables with constraints whether these are replicated or not.

Additionally these messages can be reported for non-replicated tables with unsupported datatypes.

Querying the relevant databases dictionary infomation using the queries in <Note 212044.1> indicates that the tables are present in the Streams dictionary or are not being streamed.

Streams replication is functioning normally despite these errors being reported.


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.