Re: Tough problem!!!

Posted by ErmanArslansOracleBlog on Nov 18, 2024; 1:12pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Tough-problem-tp12740p12744.html

In the log -> "19c Implementation - Drop covered objects deferred to Native Cleanup Background Job"

And yes, support is right.

With Oracle Database 19c Release Update 19.18 or later, cleanup of unused editioned objects in old database editions is handled by a background cleanup process in the database itself. A requested cleanup in adop will signal to the database that an old database edition is no longer in use, and over time the database will clean up unused objects in old editions using a background job. This will allow adop cleanup to complete much more quickly.

@$AD_TOP/sql/ADZDRUNCLEANUNUSE.sql does that job by executing

"sys.dbms_editions_utilities.clean_unusable_editions"  

adop does this only if your db version is 19c or above.

So listen what Oracle Support says.