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: Dusan Bolek <pagesflames_at_usa.net>
Date: 15 Apr 2004 02:35:01 -0700
Message-ID: <1e8276d6.0404150135.1f08d749@posting.google.com>


Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1082012459.41677_at_yasure>...
> 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
>
> I think others have told you how to drop it so I'll provide the
> information on how to keep anyone from ever doing it again.
>
> http://www.psoug.org/reference/ddl_trigger.html
>
> Look at the example titled:
> "DDL Trigger To Prevent Creating Objects That Whose Names Begin With The
> Letter 'X'"
>
> a slight variation will stop it from happening again and even allow you
> to identify the offending party.

Your example is indeed valid. On the other hand I think that if Oracle uses dot as a separator between collection of objects and its members (schema and table, package and procedure, ...), it should not permit to use dot in an object name, which is a clear violation of above described method.

--
Dusan Bolek
Received on Thu Apr 15 2004 - 04:35:01 CDT

Original text of this message

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