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

From: Rachel Carmichael <wisernet100_at_yahoo.com>
Date: Tue, 02 Dec 2003 10:54:25 -0800
Message-ID: <F001.005D86E4.20031202105425@fatcity.com>

Babette,

Version? Are you doing this through sqlplus and if so, is the client installation a different version than the db?

Rachel

• babette.turnerunderwood_at_hrdc-drhc.gc.ca wrote:
  > 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
  >
  >
  

  ---

Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.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:54:25 CST