Hi all,
I'm experiencing a problem with my RAC, an Oracle Database 12c Enterprise Edition Release 12.1.0.2.0.
Recently I dropped a table without the purge clause.
The space of course as not been release to the table space and in the dba_segments I find the BIN$ table:
Segment Name Owner Size (gb) Tablespace
BIN$YdyEBp0peEDgUws8UQol3w==$0 DISPATCH 496.9053 DATA
but if I query the user_recyclebin, the dba_recyclebin, if I issue the 'show recyclebin' command I've always "no rows selected". The table is not in the DBA_TABLES neither.
The PURGE RECYCLEBIN command works fine
SQL> PURGE RECYCLEBIN;
Recyclebin purged.
But the table is not purged (as it doesn't seem to be into the bin).
If I try the command:
drop table "BIN$YdyEBp0peEDgUws8UQol3w==$0";
I got the "ORA-38301: can not perform DDL/DML over objects in Recycle Bin"
If I issue the command:
purge table "BIN$YdyEBp0peEDgUws8UQol3w==$0";
I got the "ORA-38307: object not in RECYCLE BIN".
The same situation for the index of the primary key of the dropped table.
So...how can I purge the BIN$ table to release space to the tablespace?
Thanks in advance,
Samuel