0

When I drop the table in SQL I get a strange result. My table was not dropped but shows:

BIN$0X1RWoaWQlSLcefLZbH5jA==$0 TABLE

What is this? How can I delete the table?

Matt
  • 14,906
  • 27
  • 99
  • 149
misbah
  • 1
  • 3
    Welcome to [SO]. You might want to say which SQL software and system you are using, and show your SQL commands, otherwise it might be difficult to answer. Add the necessary details using the [edit] button. – Brian Tompsett - 汤莱恩 May 14 '16 at 09:26

1 Answers1

1

Since Oracle 10g the database has a recycle bin containing the information of dropped tables. When you drop a table it's not really dropped, just registered in the recycle bin (instead of as a "regular" table) with a BIN$ prefix and an auto-generated hash.

Once you're sure you application works properly and you really don't need this table anymore, you can get rid of it completely by using the purge command:

PURGE TABLE BIN$0X1RWoaWQlSLcefLZbH5jA==$0
Mureinik
  • 297,002
  • 52
  • 306
  • 350
  • If you don't want to type that table name (which you need to enclose in double quotes because of the lower case characters) you can also simply use `purge recyclebin` –  May 14 '16 at 13:25