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

Last updated on JULY 02, 2012

Applies to:

Oracle Server - Enterprise Edition - Version 9.2.0.1 to 9.2.0.8 [Release 9.2]
Oracle Server - Enterprise Edition - Version 10.1.0.2 to 10.1.0.5 [Release 10.1]
Oracle Server - Enterprise Edition - Version 10.2.0.1 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.
Checked for relevance on 02-Jul-2012


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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms