MFT 12c Snapshot Table Not Getting Dropped If Purge Script IS Run With No Records To Be Purged

(Doc ID 2016787.1)

Last updated on OCTOBER 25, 2016

Applies to:

Oracle Managed File Transfer - Version to [Release 12c]
Information in this document applies to any platform.


When running purge script and there are no records to purge, it will create Snapshot tables (MFT_PURGE_MESSAGE_INFO_{BatchId} and MFT_PURGE_PAYLOAD_INFO_{BatchId}) with empty values and its not got dropped by the purge script.

After running the purge script with no records purged, tables MFT_PURGE_MESSAGE_INFO_{BatchId} and MFT_PURGE_PAYLOAD_INFO_{BatchId} are created and not dropped after purge ends

Tables MFT_PURGE_MESSAGE_INFO_{BatchId} and MFT_PURGE_PAYLOAD_INFO_{BatchId} should be deleted when purge ends

The issue can be reproduced at will with the following steps:
1. Go to $MIDDLEWARE_HOME/mft/common/bin directory and run ./
2. Connect using --> connect("weblogic", "", "t3://:")
3. Run purgeInstanceData()
4. Check in _MFT schema mentioned tables are not deleted


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms