DDL extract failing with ORA-30511: invalid DDL operation in system trigger
sree_466Apr 12 2012 — edited Apr 12 2012Hi,
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