Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DDL extract failing with ORA-30511: invalid DDL operation in system trigger

sree_466Apr 12 2012 — edited Apr 12 2012
Hi,

When i tried to do any DDL operation i can see the following trace in ggs_ddl_trace.log with trace level 2.
it failing to inser record in the GGS_DDL_HIST table.
everything looks only when ddl_status.sql was run....
DDL replication is not happening.
Please help.

SESS 30445-2012-04-12 11:16:09 : DDL : Start SCN found [1147628]
SESS 30445-2012-04-12 11:16:09 : DDL : Object ID is [74635]
SESS 30445-2012-04-12 11:16:09 : DDLTRACE1 : Before Trigger: point in execution = [4]
SESS 30445-2012-04-12 11:16:09 : DDLTRACE1 : insertToMarker: inString = [
SESS 30445-2012-04-12 11:16:09 : DDLTRACE1 :
SESS 30445-2012-04-12 11:16:09 : DDLTRACE1 : ], type = [0] target = [1]
SESS 30445-2012-04-12 11:16:09 : DDLTRACE2 : insertToMarker: marker optype = [0], current_fragment = [0]
SESS 30445-2012-04-12 11:16:09 : DDLTRACE2 : insertToMarker: added fragment in part **1** [
SESS 30445-2012-04-12 11:16:09 : DDLTRACE2 :
SESS 30445-2012-04-12 11:16:09 : DDLTRACE2 : ], new current fragment [], new length of it []
SESS 30445-2012-04-12 11:16:09 : DDLTRACE1 : itemHeader: MD_TAB_DDLSTATEMENT(key1 = [] key2 = []) = [alter table "GGUSER"."TTBLE" add(column2 VARCHAR2(30)) ], itemMode = [0]
SESS 30445-2012-04-12 11:16:09 : DDLTRACE2 : escape_string: retVal = ['alter table "GGUSER"."TTBLE" add\(column2 VARCHAR2\(30\)\) ']
SESS 30445-2012-04-12 11:16:09 : DDLTRACE2 : itemHeader: retVal = [,G1='alter table "GGUSER"."TTBLE" add\(column2 VARCHAR2\(30\)\) ',]
SESS 30445-2012-04-12 11:16:09 : DDLTRACE1 : insertToMarker: inString = [
SESS 30445-2012-04-12 11:16:09 : DDLTRACE1 : ,G1='alter table "GGUSER"."TTBLE" add\(column2 VARCHAR2\(30\)\) ',
SESS 30445-2012-04-12 11:16:09 : DDLTRACE1 : ], type = [4] target = [1]
SESS 30445-2012-04-12 11:16:09 : DDLTRACE2 : insertToMarker: marker optype = [4], current_fragment = [0]
SESS 30445-2012-04-12 11:16:09 : DDLTRACE2 : insertToMarker: added fragment in part **2** [
SESS 30445-2012-04-12 11:16:09 : DDLTRACE2 : ,G1='alter table "GGUSER"."TTBLE" add\(column2 VARCHAR2\(30\)\) ',
SESS 30445-2012-04-12 11:16:09 : DDLTRACE2 : ], new current fragment [,G1='alter table "GGUSER"."TTBLE" add\(column2 VARCHAR2\(30\)\) ',], new length of it [66]
SESS 30445-2012-04-12 11:16:09 : DDLTRACE1 : insertToMarker: total_fragments = []
SESS 30445-2012-04-12 11:16:09 : DDLTRACE1 : insertToMarker: total_fragments (in loop) = [1]
SESS 30445-2012-04-12 11:16:09 : DDLTRACE1 : insertToMarker: fragment# = [1] fragment = [,G1='alter table "GGUSER"."TTBLE" add\(column2 VARCHAR2\(30\)\) ',]
SESS 30445-2012-04-12 11:16:09 : DDLTRACE1 : insertToMarker: inserting into history, objid [74635]
SESS 30445-2012-04-12 11:16:09 : DDL : insertToMarker: :ORA-30511: invalid DDL operation in system triggers
SESS 30445-2012-04-12 11:16:09 : DDL : getTableInfo: :ORA-30511: invalid DDL operation in system triggers
*SESS 30445-2012-04-12 11:16:09 : DDL : Trigger sys.GGS_DDL_TRIGGER_BEFORE :Error processing DDL operation [alter table "GGUSER"."TTBLE" add(column2 VARCHAR2(30)) ], error ORA-30511: invalid DDL operation in system triggers, error stack: ORA-06512: at "GGUSER.DDLREPLICATION", line 2486*
ORA-06512: at line 833

SESS 30445-2012-04-12 11:16:09 : DDL : Cleaning up marker sequence [17]
SESS 30445-2012-04-12 11:16:09 : DDL : Cleaned up [2] rows from marker table
SESS 30445-2012-04-12 11:16:09 : DDL : Cleaning up DDL sequence [17]
SESS 30445-2012-04-12 11:16:09 : DDL : Cleaned up [0] rows from DDL table
This post has been answered by Kamal.Sharma-Oracle on Apr 12 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 10 2012
Added on Apr 12 2012
3 comments
803 views