DDL_Setup errors and trigger SYS.GGS_DDL_TRIGGER_BEFORE is invalid
edited Jan 28, 2014 2:03AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered ✓
Hi,I am implementing DDL synchronization for golden gate between linux(source) and windows box (target) . Version of OGG
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:20:21
As part of configuring DDL synchronization, I was executing ddl_setup script and but it failed. So, I checked for the log file and found it was due to insufficient privileges.
Now, I am trying to give privileges to my gg_admin user, but it fails with below error message.
SQL> grant create any sequence to gg_admin;
grant create any sequence to gg_admin
0