How to drop all objects in the recycle bin, regardless of owner in oracle database

How to drop all objects in the recycle bin, regardless of owner in oracle database
==================================================================================
purge dba_recyclebin

how to check the original name of dropped objects in recyclebin
===============================================================
select owner,original_name,type from dba_recyclebin;

how to check view on recyclebin
===================================================
select table_name from dict where table_name like '%RECYCLE%';

Тэги:

#how #to #drop #all #objects #in #the #recyclebin #regardless #of #owner #oracle #database #oracledba #racdba #by #praveen #biyyapu

Скачать видео