What's wrong with dictionary?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: What's wrong with dictionary?

  1. #1

    Angry

    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

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Nov 2001
    Posts
    335

    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!

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?

  5. #5

    Smile 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
  •  



Click Here to Expand Forum to Full Width