PURGEOLDEXTRACTS parameter
vittelMay 23 2012 — edited May 26 2012Hi,
I need
As it's indicated in GG documentation I put the PURGEOLDEXTRACTS parameter in an Extract parameter file to delete old trail files whenever Oracle GoldenGate starts processing from a new one.
But it seeams for me that I keep all the trail files in my server!!
How I can know the unused trail files to delete them manually till now I accumulate more than 500 trail files.
here is my Extract parameter file:
extract E_DPRD
userid ogg@OSI1, password system
exttrail /oracle/product/goldengate/data/PD
PURGEOLDEXTRACTS
DBOPTIONS ALLOWUNUSEDCOLUMN
TRANLOGOPTIONS ASMUSER sys@ASM_OSI, ASMPASSWORD XXXX
wildcardresolve dynamic
TABLE OSI.;*
Regards,