Dev Anand Sadasivam Dev Anand Sadasivam - 4 years ago 182
SQL Question

Impact and Implications of drop table in Oracle

I had dropped all my tables in one of the Oracle database. And recreated the tables. While I do that, I end up with the following issue, that I found some

hash-valued
tables
created & resides when I list by
select * from cat;


select * from cat;
....
....
BIN$wNNKvu8PSDetVdeWtGc7mw==$0 TABLE
....
[..]
QRTZ_CALENDARS
....
....
....
....


Does it mean anything. Does it implies to anything.

Any advise on this matter is greatly appreciated.

Answer Source

It's a content of recyclebin.

PURGE recyclebin;

Or drop your tables with

DROP TABLE table_name PURGE;
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download