Cant drop lowercase table

From: Mark W. Aurit <maurit_at_world.nad.northrop.com>
Date: 1995/04/05
Message-ID: <D6Ksqr.Jt6_at_gremlin.nrtc.northrop.com>#1/1


I did a select from all_tables on our Oracle 6 database, and found 2 tables that caught my eye:
FIN_DOMAIN_PROJECT_T
FIN_DOMAIN_project_T
The same, except for the lower case spelling. I issued:
DROP FIN_DOMAIN_project_T, and the other table (all caps) was released. Continued attempts to dust _project_ give the error about table/view not found, yet it appears when I select on all_tables or user_tables.

What on earth is going on .. and how can I get rid of it!!!

Thx, MArk
maurit_at_world.nad.northrop.com

-- 
Mark Aurit
Finance Client/Server Systems
Northrop Grumman Data Systems (West)
maurit_at_world.nad.northrop.com
Received on Wed Apr 05 1995 - 00:00:00 CEST

Original text of this message