Re: Cant drop lowercase table
From: S. Kannan <skannan_at_PROBLEM_WITH_INEWS_GATEWAY_FILE>
Date: 1995/04/17
Message-ID: <3muj5g$op3_at_cardinal.fs.com>#1/1
Date: 1995/04/17
Message-ID: <3muj5g$op3_at_cardinal.fs.com>#1/1
Mark W. Aurit (maurit_at_world.nad.northrop.com) wrote:
: 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
-- From Kannan -------------------------------------------------------------------------------- 1919, Silver Bell Rd. #113 Eagan, MN 55 122 USA Phone: (612) 686 0157 (R) (612) 851 1878 (W) Email: skannan_at_fs.com --------------------------------------------------------------------------------Received on Mon Apr 17 1995 - 00:00:00 CEST