Data Dictionary View

Oracle Show Tables in a List

Posted on
Scope of Views on DBA_TABLES, ALL_TABLES and USER_TABLES
In this post, we will talk about three different views that can make Oracle show tables within defined scope, they are: Oracle Show Tables that You Own in a List Oracle Show Tables that You Can Use in a List Oracle Show Tables for Whole Database in a List Later on, we will talk about […]
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 […]