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
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.comReceived on Wed Apr 05 1995 - 00:00:00 CEST