Originally posted by xyz2000
Get the table name from dba_tables, then

drop table "table name";
Be careful with this!!

In my environments there are duplicate table names under different schemas. If you fail to specify the OWNER in the drop statement, you will drop whichever table has the public synonym, sometimes this can be (Elmer Fudd voice) vewy vewy bad, heh heh heh.

Always use the OWNER.TABLENAME just to be safe.

MH