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

Did you check grants on the table?

This happens sometimes, with some oracle versions, in the following situation:

step1: user1 creates tab1 and

       grants all to user2. (without grant option) step2: user2 creates view1 based on tab1

       and grants all to user3.

Now, when user3 tries to access view1 he gets this kind of error.

This can be resolved by issuing the foll sql in step1

GRANT ALL ON tab1 TO user2 WITH ADMIN OPTION;

-- 
Thanks,
Krishna

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
NOTICE:  This email message is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information.  Any unauthorized review, use, disclosure or
distribution is prohibited.  If you are not the intended
recipient, please contact the sender by reply email and destroy
all copies of the original message.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~





> 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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Krishna Kakatur
  INET: Krishna.Kakatur_at_Sun.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).