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?

Is there any setting that need to be set in Toad? No, but maybe this isn't something that's supported in your version of Toad, which came out long before Oracle 19c. Go to main menu: database -> Spool SQL -> Spool to screen. THen make the error happen again. Then post the spool sql output her…

This is part of the spool output: Session: SYS@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)( HOST=host1@example.com )(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=SDB1))) Timestamp: 17:00:32.171 Select * from sys.dba_obj_audit_opts where (SUBSTRB (alt, 1, 1) in ('-', 'A', 'S')) and ((alt <> '-/-') or (aud <…

Oh, that. 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. [image] -John

Thank you so much, that worked!!

You're welcome. You may also find some problems with getting temporary tablespace sizes in pluggable databases in 19c. Oracle changed that too. It's also fixed in the newest Toad version.

Thanks for letting me know about that too. Will try to get the new Toad version.

Could you please give me the new Toad version number which has all the fixes?

The current version is 13.2. You can keep your old version and the new one installed at the same time, just incase you need the old version for anything.

Sure, that helps. Thank you once again!

Ora-00904 ref invalid identifier with Toad 12.7.0.121

Toad for Oracle & DevOps Toolkit

nisha.n.1 January 9, 2020, 10:18pm 3

The forum is not allowing to add the spool output.

Topic		Replies	Views
Ora-00904 ref invalid identifier Toad for Oracle & DevOps Toolkit	23	14670	January 5, 2023
Toad for Oracle 16.0.90.1509 now available Toad for Oracle & DevOps Toolkit	1	4157	April 26, 2022
toad error ORA-00904: Toad for Oracle & DevOps Toolkit	2	5459	April 28, 2011
Toad for Oracle 15.0.97.1178 now available Toad for Oracle & DevOps Toolkit	1	2056	February 10, 2022
ORA-00904:"EXTERNAL": invalid identifier Toad for Oracle & DevOps Toolkit	11	2054	April 9, 2021

Ora-00904 ref invalid identifier with Toad 12.7.0.121

Related topics