SQL

How to Resolve ORA-00904 Invalid Identifier

Posted on
Oracle Database Object Name Recognition Examples
Database Object Naming Rules Normally, Oracle treats most identifiers as case insensitive ones excepts password. But there’s some special usages should be taken care of in case of ORA-00904 invalid identifier generated. Not only ORA-00904, but ORA-00903 and ORA-00911 are also related to invalid usage on object identifiers. More specifically, ORA-00903 alerts users for invalid […]
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 […]
SQL

How to Correct Invalid Identifiers in Statements

Posted on
Let’s see some wrong types of identifiers to clarify the principles. Must start with letters. RMAN> create restore point 20151028 preserve; … ORA-00904: : invalid identifier So I added a letter “s” before the identifier to correct the problem. RMAN> create restore point s20151028 preserve; Statement processed Must consist of only alphanumeric characters and the […]