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.
Vous devez être connecté et disposer d'un contrat de maintenance en cours pour afficher les articles de la base de connaissances avancés.
© ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center