Re: Cant drop lowercase table
From: Steve Edelstein <74160.645_at_CompuServe.COM>
Date: 1995/04/10
Message-ID: <3mbfdg$d6v$1_at_mhade.production.compuserve.com>#1/1
Date: 1995/04/10
Message-ID: <3mbfdg$d6v$1_at_mhade.production.compuserve.com>#1/1
Oracle holds all object names in upper case. If there's one in lower case it was created with double-quotes around the name ("xxx_YYY"). To drop the tables created like this, use the " to enclose the name, as in DROP TABLE "xxx_YYY";
Hope this helps.
-- Steve Edelstein VOICE: 212-956-3670 Relational Business Systems CompuServe: 74160,645 124 West 60th Street Suite 47C Author of New York, NY 10023 "Learning Oracle Forms"Received on Mon Apr 10 1995 - 00:00:00 CEST