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

2003-12-03 Thread babette.turnerunderwood
--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 into this problem in the past in two different

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 some

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

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

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 Subject: Anyone

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

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

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 PROTECTED] To: Multiple recipients of list

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: Re: Anyone run into this strange ORA-00904 error ??

2003-12-02 Thread ryan_oracle
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

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

2003-12-02 Thread Bellow, Bambi
Title: Message I have run into this problem in the past in two different situations. The first is where there is a reserved word somewhere that you managed to sneak through somehow... the second is where there is an internal view created for some reason that barfs... e.g.,