It this a view ?
--
Denny Koovakattu
Quoting Tanel Poder <tanel.poder.003_at_mail.ee>:
> Anyone run into this strange ORA-00904 error ??What happens if you select 1
> or 'X' from the table?
>
> Tanel.
>
> ----- Original Message -----
> From: babette.turnerunderwood_at_hrdc-drhc.gc.ca
> 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
>
----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Denny Koovakattu
INET: groups_at_koovakattu.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Dec 02 2003 - 12:09:32 CST
