--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
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
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
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
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
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
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
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
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 /
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
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.,
11 matches
Mail list logo