Hi all,
I have too many objects with name like BIN$XXXXXXX, most of them are in may USERS tablespace and it become to grow fast now. I want to remove or to clean up those recyclebin tables. What shoulld i do, is removing the objects doaesn't affect database activity or performance or shall i only remove the content.
How to remove the content of these recyclebin table. I saw on the net the command to remove the recyclebin objects like
PURGE TABLESPACE <tablespace_name> USER <schema_name>;
Is this comand will not affect tablespace content, are only the recyclebin will be removed not another objects.
Thanks for the help
regards
Raitsarevo