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

jmoses_at_lanepress.com (Jon) wrote in message news:<7436e13f.0404140925.2b615aad_at_posting.google.com>...
> 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"

I just tried Kenneth's example (on 8i) and it worked just fine with this syntax. However, I was sysdba when I deleted.

> 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

jg

--
@home.com is bogus.
Hey, people _do_ understand the money's gotta come from somewhere. 
http://www.signonsandiego.com/uniontrib/20040414/news_1n14tax.html