Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: drop a table that has a period (.) in the name

Re: drop a table that has a period (.) in the name

From: <Kenneth>
Date: Wed, 14 Apr 2004 18:51:41 GMT
Message-ID: <407d8764.2296602@news.inet.tele.dk>


On 14 Apr 2004 10:25:02 -0700, jmoses_at_lanepress.com (Jon) wrote:

>Somehow, somebody managed to create a table with a period in the name.
> I don't know how, but I'd like to break their fingers.
>
>I'd like to get rid of it, and I've tried all the quoting I can think
>of.
>
>schema."table.name"
>schema.table.name
>"table.name"
>
>and nothing works.
>
>Does anybody have any ideas as to how I might go about deleting this
>table?
>
>TIA
>-j

Give version, version, version.....

On 9.2, no problem :

SQL> create table "fnip.fnap"(c1 number);

Tabel er oprettet.

SQL> drop table "fnip.fnap";

Tabel er droppet.

SQL>

Received on Wed Apr 14 2004 - 13:51:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US