Fix the ORA-00904: ORA_ROWSCN

Fix the ORA-00904: ORA_ROWSCN: invalid identifier error in SQLDeveloper with a few easy steps

Refer: https://www.igorkromin.net/index.php/2017/08/06/fix-the-ora-00904-ora_rowscn-invalid-identifier-error-in-sqldeveloper-with-a-few-easy-steps/

Fix

Turns out fixing this problem is easy. Open up the SQL Developer Preferences, then navigate to Database > Object Viewer. Untick the box that says Use ORA_ROWSCN for DataEditor insert and update statements.

Leave a Reply