ORA-30511: invalid DDL operation in system triggers -- GGS_DDL_TRIGGER_BEFORE Causing Errors (Doc ID 1916104.1)

Last updated on FEBRUARY 02, 2016

Applies to:

Oracle GoldenGate - Version 11.1.1.1.2 and later
Information in this document applies to any platform.

Goal

GGS_DDL_TRIGGER_BEFORE causing errors:


Processing object type TRANSPORTABLE_EXPORT/INDEX/INDEX
ORA-39083: Object type INDEX failed to create with error:
ORA-30511: invalid DDL operation in system triggers
ORA-06512: at line 993
ORA-30511: invalid DDL operation in system triggers
Failing sql is:
CREATE INDEX "CLARISQA1"."AP_GL_BS_CLARIS_ACCT_ID_FK" ON "CLARISQA1"."AP_GL_BS" ("CLARIS_ACCT_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(SEG_FILE 2
8 SEG_BLOCK 3155363 OBJNO_REUSE 1303491 INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL
ORA-39083: Object type INDEX failed to create with error:
ORA-30511: invalid DDL operation in system triggers
ORA-06512: at line 993
ORA-30511: invalid DDL operation in system triggers
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms