Re: Same name for two tables

From: Valery Yourinsky <vsu_at_softexpress.ru>
Date: Thu, 24 Jun 1999 19:11:26 +0300
Message-ID: <377258ae@mail.softservice.ru>

Kenneth C Stahl <kstahl_at_lucent.com> wrote in message news:3770DEF3.FBBEF7C5_at_lucent.com...
>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).

    Or maybe they are tables even of the same schema,     But one table has name "EMP" and other table has name "Emp"     This names are different.

    If you want drop table "Emp" simply

          DROP TABLE "Emp";
    If you want drop table "EMP" simply

          DROP TABLE "EMP";
       or
          DROP TABLE EMP;

    ("EMP" and EMP (in upper case) are equal)

Valery Yourinsky
---
Softservice, Moscow
ORACLE PARTNER
tel/fax (095) 333-63-10, 128-18-21
http://www.softexpress.ru
ICQ# 3689794
second E-mail: vsur_at_usa.net Received on Thu Jun 24 1999 - 11:11:26 CDT