Re: Anyone run into this strange ORA-00904 error ??

[Tanel Poder]

Title: Anyone run into this strange ORA-00904 error ??

What happens if you select 1 or 'X' from the table?   Tanel.   ----- Original Message ----- From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Tuesday, December 02, 2003 6:34 PM Subject: Anyone run into this strange ORA-00904 error ?? 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