CODEWITHSUNDEEP
sqldatabaseoracle-databasehash
Dev Anand Sadasivam
Dev Anand Sadasivam

Reputation: 763

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.

Upvotes: 0

Views: 209

Answers (1)

hinotf
hinotf

Reputation: 1138

It's a content of recyclebin. 

PURGE recyclebin;

Or drop your tables with 

DROP TABLE table_name PURGE;

Upvotes: 1

Related Questions