Migrating From a Non-Partitioned AUDIT_TRAIL Table
A migration script is provided to migrate the TIBCO Order Management - Long Running AUDIT_TRAIL table from a non- partitioned state to a partitioned state.
The Partition_Migration_Readme.txt README file in $OM_HOME/db/oracle/oms specifies all the prerequisites and steps required to migrate the AUDIT_TRAIL table from a non-partitioned state to a partitioned state.
This migration is performed using the Oracle DBMS_REDEFINITION package without any downtime.
Although the migration script can run when the database is handling online transaction processing, it is a good practice to run this migration when there is no load or a minimal load on the database.
Any new grants required to operate are detailed in the README file.