Our database is growing rapidly, and one of the key tables, EXT_FILE_TRANS_TAB, has exceeded 20 GB in size and continues to grow significantly.
The standard External File Template process RemoveTrans does not appear to be purging records from this table. While transaction details are removed from Aurena, the corresponding records remain in EXT_FILE_TRANS_TAB.
The table contains entry from the external file template
SELECT
segment_name AS table_name,
ROUND(SUM(bytes) / 1024 / 1024 / 1024, 2) AS size_gb
FROM dba_segments
WHERE 1=1
AND segment_name = 'EXT_FILE_TRANS_TAB'
AND segment_type = 'TABLE'
GROUP BY segment_name;
Based on the documentation :
The removetrans external file will remove the old transactions.
We have tried it on STDVOU file, the removetrans file did work, we are no longer able to see the transactions on the screen, but the table still have the lines
Any idea how to purge EXT_FILE_TRANS_TAB please?
