My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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

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
Changes
Cause
Solution


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