[James Carroll]

Version: 6.0.0.zmyeclipse60020070820
Build id: 6.0.0-GA-200708
JDK/JRE: 1.6.0_3
DB: Oracle 10g Enterprise (running on localhost)
Driver: Oracle JDBC Driver v. 10.2.0.3.0

I also use Oracle’s SQL Developer.

In DB Explorer:
I connect to DB.
Create a table
—Verify in SQLDvlpr (lookin’ good!)
Right Click -> Drop Table
—Verify in SQLDvlpr (lookin’ good!)

The problem is that in DBExlpr I seem to have some kind of “ghost” that goes by the name:

BIN$oLZotAITR1a7410rP6dPNA==$0

When I go to Oracle Enterpise Manager, it appears that DBExplorer is still picking up the objects in oracle’s recycle bin. Once I purge it, the ghosts dissapear.

Anyway to remove these from at least the view or ask the user if they would like to purge as opposed to just dropping? If so, you can just add PURGE to the end of the command:

DROP TABLE TestTable PURGE

Thanks,

[Loyal Water]

Thank you for this post. Ill file this right away for my dev team.

[James Carroll]

Sweet! Thanks!

[Loyal Water]

Your welcome.

[Author]

Posts