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 <Krishna.Kakatur_at_Sun.COM> 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.
>
>
>
>
> > 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).
Pete Barnett
Lead Database Administrator
The Regence Group
pnbarne_at_regence.com
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: regdba_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 Wed Dec 03 2003 - 09:14:27 CST
