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 10.2.0.1 to 10.2.0.5 [Release 10.2]Oracle Database - Enterprise Edition - Version 9.2.0.1 to 9.2.0.8 [Release 9.2]
Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.1.0.5 [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.
Symptoms
'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.
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
| Symptoms |
| Cause |
| Solution |
| References |