Hi Experts ,.
We have ogg setup between two oracle databases with only DML uni directional replication . Its working fine .
We could see some truncate operation is happening in database through with 2 to 3 tables . We need to replicate only that truncate along with DML opreration . We are trying to add GETTRUNCATE parameter to replicate this transactions, But here the OGG user doesnt have the permission in target to replicate the truncate transaction , Since we have not enabled DDL and not granted DDL related privs due to some restriction and requirement . We have checked that , for truncate the OGG user should have drop any table permission But due to audit concern dba is not ready to grant that permission . Can you please suggest how to achieve this without drop any table permission is there any alternative way ? Please help .
Thanks
Arun .