Streams Capture Returns Errors "Missing MVDD information for the lcr" and "Fill extra attrs: Missing MVDD" (Doc ID 849851.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.5 [Release 10.1 to 10.2]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

Streams Capture  fails with the following errors logged in the alert log

Missing MVDD information for the lcr

or

Fill extra attrs: Missing MVDD

o r

Missing MVDD for object ID nnn

A trace file is also generated.

An alert log on the target database (where the Apply process is running) will also show the “Missing MVDD for object ID nnn” message.

Changes

A maintenance is being performed on a captured (replicated) object -  for example:

ALTER TABLE aaa MOVE PARTITION bbb
TABLESPACE rrr;

or

ALTER TABLE aaa MODIFY PARTITION bbb
COALESCE SUBPARTITION;

or

ALTER TABLE aaa COALESCE;

or

ALTER CLUSTER ccc DEALLOCATE UNUSED KEEP 1M;

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