Re: How can I drop an oracle table imported from MS access. HELP ME
From: Wayne G. Belles <71055.154_at_compuserve.com>
Date: 1996/05/28
Message-ID: <4odl7s$mb9_at_arl-news-svc-2.compuserve.com>#1/1
Date: 1996/05/28
Message-ID: <4odl7s$mb9_at_arl-news-svc-2.compuserve.com>#1/1
jean-claude bodart <jean-c.bodart_at_roche.com> wrote:
>I imported a table from ODBC/MS Access. The table name is
>shown in oracle in lowercase character. I cannot drop this
>table because of the lowercase char.
>Could you help me
>Thank you
>Jean-claude
You should be able to drop by using quotation marks. I don't recall if it is double quotes or single. I think it is double. Using the lowercase name.
drop table "tablename";
Wayne Belles Received on Tue May 28 1996 - 00:00:00 CEST