Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Same name for two tables

Re: Same name for two tables

From: Frank Hörner <hoerner_at_mgi.de>
Date: Thu, 24 Jun 1999 07:26:43 +0200
Message-ID: <3771C193.C570E0A3@mgi.de>


Hi there !!

Had you take a look at sys.dba_tables where table_name = 'yourtagname' ? It seems to me that the tables have been created by different owners. If its so, then you only have to drop the table with the wrong owner

Frank

Fred Ruffet schrieb:

> 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 Thu Jun 24 1999 - 00:26:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US