Ora-00904 ref invalid identifier with Toad 12.7.0.121

 Problem:

I am trying to access the Script tab of tables in Toad (version 12.7.0.121) and getting ora-00904 ref invalid identifier. The database is 19c.

I don't see this error with 12.2 version of database.
Is there any setting that need to be set in Toad?

Solution:

Yes, Oracle got rid of the "REF" column in DBA_OBJ_AUDIT_OPTS in 19c. The current version of Toad does not include this column in the SQL.

You can avoid the error by unchecking auditing in the script options.

YouTube Link : https://www.youtube.com/c/baizeedrony/videos