Order purging Through SQL
SQL based purge script has been provided as the main tool to remove the orders from the database. Refer to the tool's ReadMe present under $OM_HOME/db/oracle/purge to execute the purge.
Note: It is best practice to purge orders through truncating partitions.