Re: Weird Table Name in Oracle 7.3.4

From: Leonel Sanhueza <lsanhuez_at_udec.cl>
Date: Thu, 01 Oct 1998 20:35:07 -0400
Message-ID: <36141FB9.F65FC2A2@udec.cl>

Hello Steve
Try next

SQL> drop table "q198.jan.98";

When you appends the character " before and after the name of the table, this
will be created literal, with upper and lowercase.

Leonel Sanhueza J.
Universidad de Concepcion
lsanhuez_at_udec.cl

Steve Mitchell wrote:

> One of our users has managed to create a table name as follows:
>
> q198.jan.98
>
> This is how it shows when querying dba_tables. Note that it is in lower
> case and contains periods.
>
> How was the user able to do this? I am not able to describe it in
> SQL*Plus or even attempt to remove the offending table. I am thinking
> of directly changing the data in the data dictionary so that I can
> remove this table but would rather not.
>
> Steve.
Received on Thu Oct 01 1998 - 19:35:07 CDT