Dropping Old Partitions
Dropping old partitions is only supported for a PostgreSQL database.
- PostgreSQL Users:
For a PostgreSQL database, partitions can be dropped by running the drop_partition_by_name.sql file.
Refer to the Partition_Drop_Readme.txt file under $OM_HOME/db/postgreSQL/purge for additional details on the setup and run procedure.
Note: Dropping a partition in a PostgreSQL database is allowed only when all of the orders in that partition are eitherCOMPLETE
orCANCELLED
. If there are any open orders in the partition, the drop partition process cancels.In case a partition has open orders, you can use the purge orders script $OM_HOME/db/postgreSQL/purge/OMS_purge_orders.sh to purge selective orders instead.