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
