Migrating From a Non-Partitioned AUDIT_TRAIL Table

A migration script is provided to migrate the TIBCO Fulllment Order Management AUDIT_TRAIL table from a non- partitioned state to a partitioned state.

The Partition_Migration_Readme.txt README file in $AF_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 down time.

Although the migration script can run when the database is handling online transaction processing, it is recommended to run this migration when there is no load or a minimal load on the database.

Any new grants required to perform the operation are detailed in the README file.