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 )
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center