"ORA-00904 invalid identifier" in *desvr* log during compare (4330229)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

"ORA-00904 invalid identifier" in *desvr* log during compare
Description

The compare fails with the desvr log showing the following:

Source Table: <owner>.<tablename>
Oracle Error 904: ORA-00904: "<column_name>": invalid identifier
Cause

A wrong column name has been used in compare command.
Resolution

If using a "where" clause in compare; check to make sure to use the correct column name, otherwise compare will fail with ORA-00904.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

"ORA-00904 invalid identifier" in desvr log during compare (4330229)