Issued alter table add column DDL for multiple columns but did not replicate
Event_log:
Poster: Oracle error: ORA-00900: invalid SQL statement. rowid:N/A (posting from {Source SID}, queue {name}, to {Target sid}) [module opo]
Error 2011-06-15 10:57:27.409756 5216 4046453648 s:2 Poster: 15033 - Failed to execute SQL on table "{OWNER}"."{NAME}": ORA-00900: invalid SQL statement. (posting from {Source SID}, queue {name}, to {Target sid}) [module opo]
Capture log:
ocap_ddl 2011-06-15 10:38:34.702165 4660 4136863952 User Name: "{OWNER}" Status: Replicated (Inferred)
ocap_ddl 2011-06-15 10:38:34.702165 4660 4136863952 DDL = alter table {NAME}add (
ocap_ddl 2011-06-15 10:38:34.702165 4660 4136863952 {column name1} VARCHAR2(1) DEFAULT 'N' NOT NULL,
ocap_ddl 2011-06-15 10:38:34.702165 4660 4136863952 {column name2} NUMBER DEFAULT 180 NOT NULL
ocap_ddl 2011-06-15 10:38:34.702165 4660 4136863952 )
Post has issue applying DDL to add multiple columns
Resolution
Contact Quest Support
Workaround:
1.Ignore the DDL messages for Posting.
2.Apply the DDL manually on Target .
Status : Will be addressed in later version.
To Avoid this problem issue DDL to add one column at a time on source.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center