We started having a weird problem that looks like some kind of data dictionary corruption.
My first choice is to run catalog / catproc. This did nothing to resolve the problem.
Why am I able to describe an object, but get ORA-00904 when I try to select from the table...
SQL> desc ispownre3.individual_names;
Name Null? Type
----------------------------------------- -------- ------------------
INTERNAL_IDENTIFIER NUMBER(12)
TITLE_CD NUMBER(3)
. . .
SQL> select * from ispownre3.individual_names;
select * from ispownre3.individual_names
*
ERROR at line 1:
ORA-00904: invalid column name
