Skip to main content

Community

Other: New partitions created in Oracle are not enrolled in HVR repository automatically

Please sign in to leave a comment.

Comments

1 comment

    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.