A supported DDL is not replicated to target despite SP_OCT_REPLICATE_DDL set to 3. The replication is otherwise working fine. The Capture DDL log states that the DDL has been captured and sent to target:
ocap_ddl 2013-06-27 10:07:12.133942 30771 2444290048 Oracle Time: 06/27/13 10:07:10 object=PITEST.RPTOPENDATA_TEMP
ocap_ddl 2013-06-27 10:07:28.028312 30771 2444290048 User Name: "user_name" Status: Replicated (Inferred)
ocap_ddl 2013-06-27 10:07:28.028312 30771 2444290048 DDL = ALTER TABLE owner.table_name ADD (initiator VARCHAR2(20) NULL, extview CHAR(1) DEFAULT 'N' NULL)
The Post DDL log (*opo* *ddl*) also confirms that the DDL is posted:
opo_ddl 2013-06-27 10:07:11.292253 11999 3854641472 s:2 Alter table DDL posted:
opo_ddl 2013-06-27 10:07:11.292328 11999 3854641472 s:2 SQL = "ALTER TABLE owner.table_name ADD (initiator VARCHAR2(20) NULL, extview CHAR(1) DEFAULT 'N' NULL)
But the DDL is not posted.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center