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

[Guerra, Abraham J]

Title: Message

Would an export/drop/import work for you?

 

Abraham

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 10:34 AM
To: Multiple recipients of list ORACLE-L
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