When running a query on a table with specifying column names, the following message appears. Using the * wildcard in query, query executes OK.
ORA-00904 <column name> invalid identifier
The error also occurs when executing the query in SQLPlus.
Table was created with another tool, such as Access import feature. The create script contains double quotes around each column name. This can be verified via Toads Schema Browser | Tables | Script tab.
Recreate the table using a Create Table statement that does not contain double quotes around the column name and reimport the data to table.
