Convert non-partitioned table to partitioned table using DBMS_REDEFINITION

I had a request from my users that suddenly one of the query is running slowly. I did the usual checks, SQL Plan regression, storage response time, load on the database, there was nothing unusual. Then I told my user that the elapsed time for this query is as usual and the plan has not changed … Continue reading Convert non-partitioned table to partitioned table using DBMS_REDEFINITION