Other: New partitions created in Oracle are not enrolled in HVR repository automatically
Hello,
We have new partitions being added on Oracle database (Source) on daily basis.
These new partitions are not enrolled in HVR repository automatically, until manual reactivation of tables in HVR.
We need fix for this, since we have many tables replicating and we cannot come to know about new partitions until we check data in Target database (Snowflake). There is no errors or information in HVR log files when a new partition is added.
Thanks
Vadiraj Honwad
-
Hi Vadiraj,
Are new partitions added? Or do you split a partition each time when a new partition is added (e.g. the partition with the upper boundary)?
Adding a partition (alter table ... add partition ...) should add the partition to the table, whether it is manually added or as part of an interval partitioning setup.
Other operations to add a partition like splitting or exchanging partitions require the use of AdaptDDL to add partitions, and may result in a refresh operation (which I imagine you don't want).
Please describe your scenario in more detail. Also, what is your partitioning scheme?
Thank you,
Mark.
Please sign in to leave a comment.
Comments
1 comment