Re: Same name for two tables

From: Chris Nelson <ChrisNelson_at_eaton.com>
Date: Thu, 24 Jun 1999 00:39:27 -0400
Message-ID: <3771B67E.23667569@eaton.com>

I have noticed a similar conundrum in Oracle Manufacturing. I ran the following query once when I noticed what seemed to be an impossibility: two different table_name values with the same table_id in applsys.fnd_tables.

select a.table_name

 , a.table_id
 , b.table_name
 , b.table_id

from applsys.fnd_tables a
 , applsys.fnd_tables b
where a.table_id = b.table_id
and a.table_name <> b.table_name
/

I came up with 92 rows in the results ! In other words, it's not so impossible as I thought: there are 46 pairs of 'different' table_name that share the same table_id.

I'd like to know 'how !?!' even before I find out 'why ?'.

Chris

Fred Ruffet wrote:

> I work on an Oracle 7.3.4 database. It happens that I have to tables in this
> database, that have the same name. I don't know how they were created, but
> in the sys table sys.obj$, they are distinct objects. The second one has
> never been modified (ctime=mtime), because, I believe, every modification
> has been done on the first one.
> How could I get rid of the second one ? Do I only have to delete its
> occurence from sys.obj$ ?
> Is it an Oracle bug ?
>
> Thanks for any answer,
>
> --
>
> Frédéric Ruffet - fruffet_at_kaptech.com
> "Rest is silence" - W. Shakespeare
Received on Wed Jun 23 1999 - 23:39:27 CDT