I have a huge table that is partitioned by month going all the way back to July 2000. As the partitions are backup they are made read only because the data never changes.

I have to add a column to the table. How does this affect the read only tablespaces associated with this table? Do have have to make those partitions read write again and then back them up again??