-
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
Queyon Zeng
-
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"
Jeff Hunter
-
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!!!
One, who thinks that the other one who thinks that know and does not know, does not know either!
-
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.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Thank you!
Marist89 is right.
Thank all of you for the help.
Queyon
Queyon Zeng
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|