What's wrong with dictionary?

[Queyon]

In Oralce 8.1.6.3.4 on Windows NT 4.0 SP6a.

select owner, object_name, object_type
from dba_objects
where owner = 'XXX'
and upper(object_name) = 'AAAAAABBBB';

It returns 2 rows, one is in uppercase, the other one is in capital lowercase. The output looks like:

OWNER OBJECT_NAME OBJECT_TYPE
---------- ---------------------------------------- ------------------
XXX AAAAAABBBB TABLE
XXX AaaaaaaBbbb TABLE

What's wrong with Oracle dictionary?
Is there any bug to be applied?
Any help will be appreciated.
Thanks.

Queyon

[marist89]

There is probably nothing wrong with the dictionary. You probably really have two tables, one named AAAAAABBBB and one named "AaaaaaaBbbb". To verify:
desc XXX.AAAAAABBBB
desc XXX."AaaaaaaBbbb"
select count(*) from XXX.AAAAAABBBB
select count(*) from XXX."AaaaaaaBbbb"
insert into XXX.AAAAAABBBB values (...)
select count(*) from XXX.AAAAAABBBB
select count(*) from XXX."AaaaaaaBbbb"

[BV1963]

I believe you do not see a tail of the name and that is why they appear to be the same. Below is example:


select object_name,owner from dba_objects where object_name like '%AAA%';

OBJECT_NAME
-------------------------------------------------------------------------------------------
AAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAB


COL OBJECT_NAME FORMAT A10;


SET WRAP OFF


OBJECT_NAM OWNER
---------- ------------------------------
AAAAAAAAAA SYSTEM
AAAAAAAAAA SYSTEM



Thing happen!!!

[jmodic]

Originally posted by BV1963

I believe you do not see a tail of the name and that is why they appear to be the same.

You've missed the point. It is very evident that Queyon has two tables with the same names, except that one is in uppercase (default), the other one in mixed case. Those are two different tables for Oracle, and as Jeff has allready pointed out you have to use double quotes to reference a mixed-case-named table.

[Queyon]

Marist89 is right.
Thank all of you for the help.

Queyon