I further tested inherited tables flow as well wrt ONLY and EXCEPT, it works well. But while reading docs for the saem, I have few concerns.
1) While explaining ONLY for EXCEPT, create-publication doc says this + This does not apply to a partitioned table, however. The partitions of + a partitioned table are always implicitly considered part of the + publication, so they are never explicitly excluded from the publication. I do not understand the last line: "so they are never explicitly excluded from the publication" . But we can explicitly exclude them using EXCEPT <partition_name>. Do you mean to say something else here? 2) alter-publication doc says (in context of EXCEPT): "If ONLY is specified before the table name, only that table is affected. If ONLY is not specified, the table and all its descendant tables (if any) are affected. Optionally, * can be specified after the table name to explicitly indicate that descendant tables are affected." But it does not mention anything for partitions. I think we shall mention here as well that this does not apply to a partitioned table. (I tested ONLY and EXCEPT for partition-root. UNLIKE inherited tables, ONLY has no impact on partitioned tables.) 3) Shall we explain the relation of 'publish_via_partition_root' with EXCEPT briefly in docs(once we conclude that design)? Please note that I have performed all the tests (mentioned here and in previous emails) on patch001 and patch002. patch003 is not applied in these tests. thanks Shveta
