Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Same name for two tables
Don't ever modify sys.obj$ directly. In fact, never modify any table owned by
sys or system directly.
log in as SYSTEM and select * all_catalog where table_name = 'xxx';
where xxx is the table name you are looking for. Look at the results and you'll either see that the two objects are either owned by different schemas or else they are different types of objects (i.e. one is a table and the other is a sequence or something like that).
If you find that both of them are tables and you can figure out which one isn't being used, then just do a "drop table owner.table".
Ken
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 - 08:19:47 CDT