Streams Apply stops with ORA-55610 when destination tables are in a flash data archive (Doc ID 801134.1)

Last updated on JUNE 21, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.1.0.7 - Release: 11.1 to 11.1
Information in this document applies to any platform.

Symptoms

DDL statement was captured on the source database and propagated to destination database but the apply fails with ORA-55610
When we use print_errors procedure for the failing transaction we see the error ORA-55610 for that transaction.


SQL> exec print_errors
*************************************************
----- ERROR #1
----- Local Transaction ID: 5.20.7503
----- Source Database: TEST1
----Error in Message: 1
----Error Number: 55610
----Message Text: ORA-55610: Invalid DDL statement on history-tracked table

--message: 1
type name: SYS.LCR$_DDL_RECORD
source database: TEST1
owner: TEST1
object: TABLE1
is tag null: Y
ddl: alter table TABLE1 modify NEWVALUE varchar2(400)

PL/SQL procedure successfully completed.

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