I an able to create, describe, drop a table called q198.jan.98 by enclosing
the table name in double quotes. Try drop table "q198.jan.98";
Steve Mitchell wrote in message <3612B197.8ABA55FC_at_mitchells.demon.co.uk>...
>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 - 12:46:27 CDT
