Re: Same name for two tables

From: Kenneth C Stahl <kstahl_at_lucent.com>
Date: Fri, 25 Jun 1999 07:55:59 -0400
Message-ID: <37736E4F.EE937E71@lucent.com>

I'd say ditch the Borland product. It is giving you bad information. If you have an Oracle installation CD then just install the client tools on your pc and use Schema Manager. It will give you reliable information about your database.

Ken

Fred Ruffet wrote:

> So, it's not an Oracle problem !!! when I run the select you told me, here
> is what I obtain :
>
> SQL> select * from dba_objects where object_name = 'COMPTE';
> OWNER
> ------------------------------
> OBJECT_NAME
> ----------------------------------------------------------------------------
> ------------------------
> OBJECT_ID OBJECT_TYPE CREATED LAST_DDL
> --------- ------------- -------- --------
> TIMESTAMP
> STATUS
> ---------------------------------------------------------------------------
> -------
> GESTECH
> COMPTE
> 5024 TABLE 15/09/98 21/01/99
> 1999-01-21:10:42:47
> VALID
> GESTECH
> COMPTE
> 5025 INDEX 15/09/98 15/09/98
> 1998-09-15:18:18:22
> VALID
>
> So, one is a table, the other an index. It seems good, except that the
> program I use (Borland Database Explorer) shows me two tables named COMPTE,
> each one with an INDEX named COMPTE... How should I consider this ?
Received on Fri Jun 25 1999 - 06:55:59 CDT