You Asked
Hi Chris/Connor,
Can you please help to clarify below query:
We have a Archival requirement, where we need to :
1. Copy certain tables data (older than 7 years) from Primary DB to secondary DB
2. Delete those copied data from Primary DB.
So our Secondary Data will be holding all current data as well as historical data.
Looking at the Golden Gate guide, it is used to sync two databases table data.
Can GoldenGate be used to delete data from a database?
and we said...
Can GoldenGate be used to delete data from a database?
The answer to your question is simple, yes. You have to keep in mind, that when GoldenGate is configured, any DML or DDL that is ran and commited on the source system will be replicated to the target system on a table-by-table bases. This keeps the two systems in sync with each other.
Your requirement to delete from the source table but keep the data in the target, you can use the IGNOREDELETES parameter (
http://docs.oracle.com/goldengate/c1230/gg-winux/GWURF/getdeletes-ignoredeletes.htm#GWURF509 ). This parameter controls whether or not GoldenGate will process the delete DML operations. This parameter can go into either your extract or replicat parameter file.
Enjoy!!!
Rating
(1 rating)
Is this answer out of date? If it is, please let us know via a Comment