How to change a replicating table from partitioned to non-partitioned table or vice versa (4301248)

How to change a replicating table from partitioned to non-partitioned table or vice versa

How to change a replicating table from partitioned to non-partitioned table or vice versa 

General information.

The steps involved are:

1) Make a copy of the currently active config file and comment out the table in the copy.

2) Activate the copy so that the table is now taken out of replication

3) Make the table non-partitioned (or partitioned as applicable)

4) Activate the original config file so as to bring the now non-partitioned (or partitioned as applicable) table back into replication.

NOTE : Make sure there is no user activity on the table between steps 2 and 4. Otherwise table will be out of sync.  

For details on steps involved in converting the table from partitioned to non-partitioned table or vice versa, refer to Oracle documentation. There are multiple ways to do that.