[jeffhoran]

I have many BIN$ files and want to get rid of them. When I drop tables they are sent to recycle and renamed BIN$…. There is no delete and I can’t do it with DROP BIN$… So, I have several BIN$… tables and can’t get rid of them.

I have:
ME 4.1 GA
E 3.1.1
MS XP Pro
Oracle db (thin)

Thx

[snpe]

BIN$ are oracle system objects, probably.You haven’t to remove it
how you make connection ?
where are this tables – which schemas ?

[jeffhoran]

I found this at OTN:

1) Eventually, they will be removed automatically, so you don’t need to do anything to remove them.

2) If you want to purge everything in the recycle bin,

PURGE recyclebin
PURGE dba_recyclebin

3) If you want a particular object not to go into the recycle bin

DROP TABLE <<table name>> PURGE

Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

[bgblanch]

What database version are you using? I know with 10g anything that is dropped or deleted is saved in a trash for use with the flashback utility.

[jeffhoran]

Thx. When I found out that they just disappear, that was enough for me. They have disappeared.
I am using 10g. Thanks.

[Haris Peco]

What database version are you using? I know with 10g anything that is dropped or deleted is saved in a trash for use with the flashback utility.

just for information ; recovery area isn’t in trash – there is special area for flashback (flashback data don’t dissapear after rebooting)

best

[Tim Howland]

anybody got a way to keep the recyclebin objects from showing up in the DB explorer? It’s distracting when you’ve got several dozen $BIN objects in there. I’d like to keep them around in case I mess up, but I’d much prefer not to see them…

[Author]

Posts