Hi Vignesh, I noticed it is not currently possible (there is no syntax way to do it) to ALTER an existing publication so that it will publish SEQUENCES.
Isn't that a limitation? Why? For example,. Why should users be prevented from changing a FOR ALL TABLES publication into a FOR ALL TABLES, SEQUENCES one? Similarly, there are other combinations not possible DROP ALL SEQUENCES from a publication that is FOR ALL TABLES, SEQUENCES DROP ALL TABLES from a publication that is FOR ALL TABLES, SEQUENCES ADD ALL TABLES to a publication that is FOR ALL SEQUENCES ... ====== Kind Regards, Peter Smith. Fujitsu Australia
