Toad World® Forums

SQL/BATCH OPTIMIZE SQL INVALID SQL/IDENTIFIER

First time using both Optimize SQL & Batch Optimize SQL. I’m just using a basic SQL statement for both and I keep getting a Invalid SQL with an ORA-00904 - Invalid Identifier. I put in the schema and execution schema name and I still get the error. any suggestions?

SELECT AC_CD,

AC_DESC,

AC_CREATE_BY,

AC_CREATE_DT,

AC_UPDATE_BY,

AC_UPDATE_DT,

AC_CLOSE_DT

FROM (SCHEMA NAME).ACT_CDS

Toad has a SQL Tracker that can monitor SQL statements executed by an application. Please use it to monitor SQL Optimizer to capture what SQL were being executed while the error occurred. Once you have the log, please send to Support and ask for opening a support case. We can look into more details from there.

Also, knowing the definition of the object you have in the SQL (ACT_CDS) will also be helpful to troubleshoot the problem. If it is a synonym or view, information of the base objects will also be needed.

Thanks,

Alex