I've had a table inadvertently created by another program where the owner name becomes part of the table name. For example:
owner: XYZ
table: ABC.TABLENAME
When I right clicked on this table in the browser and dropped it (connected as user XYZ), this table was dropped instead:
owner: ABC
table: TABLENAME
It appears to drop table "XYZ"."ABC.TABLENAME" but when the browser is refreshed, that table is still there and "ABC"."TABLENAME" is gone.
I'm using PL/SQL Developer 6.06.947 with both Oracle 9.2.0.5.0 and 10.2.0.1.0.
owner: XYZ
table: ABC.TABLENAME
When I right clicked on this table in the browser and dropped it (connected as user XYZ), this table was dropped instead:
owner: ABC
table: TABLENAME
It appears to drop table "XYZ"."ABC.TABLENAME" but when the browser is refreshed, that table is still there and "ABC"."TABLENAME" is gone.
I'm using PL/SQL Developer 6.06.947 with both Oracle 9.2.0.5.0 and 10.2.0.1.0.