Capture Fails With Ora-26773 After Rebuilding A Table In Source Database Using Move Command (Doc ID 733040.1)

Last updated on AUGUST 19, 2008

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0.7
This problem can occur on any platform.

Symptoms

-- Problem Statement:
In a STREAMS environment , one of the tables (that has LOB datatypes) has been rebuilt using
following command :

SQL> alter table PICK_LIST move;


Right after having done so, CAPTURE is aborted with the error:

ORA-26744: STREAMS capture process "ADVANTEX_CAPTURE" does not support "DOTNET1_ODB"."PICK_LIST" because of the following reason:
ORA-26773: Invalid data type for column "malformed redo"


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