DDL

How to Resolve OGG-00519 REPLICAT DDL Errors in GoldenGate

Posted on
OGG-00519 In the remote database, you may not create all objects to resolve dependency problems. Here are some OGG-00519 DDL errors in REPLICAT report below: 2017-08-22 19:52:03  ERROR   OGG-00519  Fatal error executing DDL replication: error [Error code [1435], ORA-01435: user does not exist SQL ALTER SESSION SET CURRENT_SCHEMA=”PUBLIC”], no error handler present. 2017-08-23 20:18:54 […]
GoldenGate

How to Resolve OGG-00519 with ORA-00942

Posted on
Recently, I initialized a set of EXTRACT / PUMP / REPLICAT for one schema, but some days after, the REPLICAT abended with this error: 2017-05-10 18:47:15  ERROR   OGG-00519  Fatal error executing DDL replication: error [Error code [942], ORA-00942: table or view does not exist SQL alter table HR.EMPLOYEES modify … We saw OGG-00519 as […]
User and Schema

How to Resolve ORA-01031: Insufficient Privileges When Creating View Via Role’s Privilege

Posted on
Some privileges inherited from the role might not work in some situation, especially when accessing intermediate kinds of object, like view or store procedure. Here is a case that can reproduce the error. Check the privileges on HR. [oracle@primary01 ~]$ sqlplus / as sysdba … SQL> select privilege from dba_sys_privs where grantee = ‘HR’; PRIVILEGE […]