Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Same name for two tables
Frederic
In order for two tables, or any other object for that matter, to have the same name, they must be in different schemas.
The first table you mention is being changed because the changer is connecting to the schema in which it is defined. the second one is not changing because noone connects to its schema to change it.
To get rid of the table that you do not want, find out the schema it is defined in, connect to that schema, and drop the table.
Under NO circumstances should you operate directly on ANY object defined in the sys schema, especially if it has '$' in its name, unless directed to do so by Oracle support. Doing so may cause irreparable damage to your database.
Hope this helps.
Mark.
On Wed, 23 Jun 1999 14:50:34 +0200, "Fred Ruffet" <fruffet_at_kaptech.com> 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 Thu Jun 24 1999 - 08:09:19 CDT