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: Tanel Poder <change_to_my_first_name_at_integrid.info>
Date: Thu, 15 Apr 2004 00:00:05 +0300
Message-ID: <407da657_2@news.estpak.ee>


> 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"

When you put the table name in quotes, then the table names are case sensitive.

Try to use schema."TABLE.NAME" if your table's name is all uppercase in data dictionary.

Tanel. Received on Wed Apr 14 2004 - 16:00:05 CDT

Original text of this message

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