Recycle is User specific!
Adrian Ward, February 11, 2020 - 7:43 am UTC
I now know why I thought the recycle bin was empty - I ran the scripts from the admin account, including the purge script, but that did not delete the other users recyclebin entries.
The admin account has elevated rights, including the inky one that can read dba segments.
Is there a DBA like purge command that will empty all bins for the cloud Admin account? Or do we have to log in as every user?
Adrian
February 11, 2020 - 10:32 am UTC
You can empty the dba recyclebin when connected to the admin account:
purge dba_recyclebin;