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

2003-12-03 Thread Richard Ji
I have also seen a case where new line or other weird ASCII charater find they way into the name that could cause this behavior. -Original Message- Sent: Wednesday, December 03, 2003 10:14 AM To: Multiple recipients of list ORACLE-L Sometimes the upper case and lower case get mixed up in

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

2003-12-03 Thread Peter Barnett
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

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

2003-12-03 Thread babette.turnerunderwood
PROTECTED] 954-3752 (Mon - Fri 7am - 3pm) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bellow, BambiSent: 2003-12-02 6:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Anyone run into this strange ORA-00904 error ?? I have run int

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

2003-12-02 Thread Bellow, Bambi
CLE-LSubject: 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

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

2003-12-02 Thread ryan_oracle
gt; Subject: 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 gr

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

2003-12-02 Thread Rachel Carmichael
Babette, Version? Are you doing this through sqlplus and if so, is the client installation a different version than the db? Rachel --- [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 /

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

2003-12-02 Thread Denny Koovakattu
It this a view ? -- Denny Koovakattu Quoting Tanel Poder <[EMAIL PROTECTED]>: > Anyone run into this strange ORA-00904 error ??What happens if you select 1 > or 'X' from the table? > > Tanel. > > - Original Message - > From: [EMAIL PROTE

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

2003-12-02 Thread Krishna Kakatur
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 a

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

2003-12-02 Thread Daniel Fink
Babette, Can you list the describe of the whole table? Daniel FInk [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 a

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

2003-12-02 Thread Tanel Poder
Title: Anyone run into this strange ORA-00904 error ?? What happens if you select 1 or 'X' from the table?   Tanel.   - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Tuesday, December 02, 2003 6:34 PM Subje

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

2003-12-02 Thread Guerra, Abraham J
Title: Message Would an export/drop/import work for you?   Abraham -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 10:34 AMTo: Multiple recipients of list ORACLE-LSubject: Anyone run into this strange ORA-00904 error ?? We

Anyone run into this strange ORA-00904 error ??

2003-12-02 Thread babette.turnerunderwood
Title: 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