Toad Beta 24.2.229.4528
Oracle Free 23.3.0.23.9
Schema browser/ alter selected table get error
"ORA-00904: "VECTOR_INFO": invalid identifier"
"Rebuild table" gives the same error.
On other versions of the Oracle the error does not appear
I tried this on 23ai with regular tables, and a table with various vector datatypes and I'm not seeing it. Can you send DDL for a sample table that will produce this error?
I'm running 23.4 so it's possible that this could be an Oracle bug that was fixed.
Thanks
This happens on any table, no matter what DDL Even on TOAD_PLAN_TABLE
And only "Oracle Database 23c Free" version.
Looks like we are querying SYS.USER_TAB_COLS for the VECTOR_INFO column which is new in 23ai, but for some reason not there for your instance. I'm going to have to defer to the developer on this one...
I can reproduce this with the 23c version that was released before the 23ai.
I will have it fixed in next Toad beta.