Hi everyone,
I'm a beginner DBA and I've been having some issues with an Oracle Database 19.3.
I have some tables in dba_recyclebin, and they are making my queries slow.
For example:
- When I run
PURGE DBA_RECYCLEBIN;, my query takes around 0.150s.
- When there are objects in
dba_recyclebin, the same query can take around 8 minutes to finish.
Slow section-
SELECT TRUNC(SUM(bytes)) AS FREE, file_id FROM cdb_free_space GROUP BY file_id) f
My question:
I'd like to drop a specific object from the recycle bin, but I'm getting the following error:
SQL> PURGE TABLE "TOTVS"."BIN$Qk+cehpcQ2ngYyYAqMDhTA==$0" ORA-38307: object is not in the recycle bin
Help: https://docs.oracle.com/error-help/db/ora-38307/
I do not have a CDB.
Can I use the real table name, like:
PURGE TABLE "TOTVS"."FWTSEVENTVIEWER1";
to purge it directly? Also, could doing this cause any problems with my database or data integrity?
Does anybody have any advice or solutions to help me?