Deleting an OGG Flat File Extract Adapter and its cpe file does not completely delete its Checkpoints and References
Last updated on JULY 17, 2017
Applies to:Oracle GoldenGate Application Adapters - Version 188.8.131.52.12 and later
Information in this document applies to any platform.
If I delete the extract completely, which also removes the checkpoint log file and the .cpe file, it doesn't appear as though the extract has been completely deleted. When I begin a new extract dealing with completely different tables, even with a new group name, the new extract looks for the old data files (I can see this in the flat file log where it says it's trying to open one of the old data files). Furthermore, if the new extract is dealing with tables that are the same as the old extract (even though the extract has been deleted and the old data files have been deleted), the new extract creates data files starting from the last numeric position of the last old data file. Where is this "old" information kept, and how does one start over completely?
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