Sometimes the upper case and lower case get mixed up in the data dictionary. I know that Oracle claims case insensitivity but it happens. Take a look at sys.col$ and sys.obj$.
--- Krishna Kakatur <[EMAIL PROTECTED]> wrote: > > 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. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > > > > [EMAIL PROTECTED] 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). ===== Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __________________________________ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Barnett INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
