Grants Are Not Replicating In Golden Gate
SYMPTOMS
Grants are not being replicated from source to target when using Integrated extract
CAUSE
Bug 30120608 : Capture skipping included grant after an excluded alter
If using OGG IE and DDL is excluded when it should be included then this bug may have been encountered.|
Issue is observed when IE encounters an excluded alter statement followed by an included grant. The Grant statement also gets excluded.
If you create a new Integrated Extract, the grants get captured.
SOLUTION
Apply fix for Bug 30120608 to address the grant issues observed
Reference: Metalink Doc ID 2609445.1
Recent Posts