Re: Cant drop lowercase table

maurit_at_world.nad.northrop.com (Mark W. Aurit) writes:

>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

Try putting the table name in quotes. I don't know how the table got created in the first place.

    -Pat Connors Received on Tue Apr 11 1995 - 00:00:00 CEST