Purge script to remove entries from the order messages table

Now, the non-partition to partition migration script converts the order_messages table into a partitioned table. The script has been added to upgrade_6.0.0hf1_to_6.0.0hf2_step.cmd and upgrade_6.0.0hf1_to_6.0.0hf2_step.sh files for both the PostgreSQL and Oracle. It is important to note that before running the partitioned script, users must ensure that they have the necessary grants.

Before you run the script, provide the following permissions to the user:

grant resource, connect, create session to OM_ORDER_US5;
grant alter session to OM_ORDER_US5;
grant execute on dbms_redefinition to OM_ORDER_US5;
grant create any sequence to OM_ORDER_US5;
grant create any table to OM_ORDER_US5;
grant alter any table to OM_ORDER_US5;
grant drop any table to OM_ORDER_US5;
grant lock any table to OM_ORDER_US5;
grant select any table to OM_ORDER_US5;
grant create any index to OM_ORDER_US5;
grant create any trigger to OM_ORDER_US5;
grant create any job to OM_ORDER_US5;

When you purge the final state orders from the order database, the entry is deleted from the order_messages table along with other tables.