Originally published here by Terry Wright, July 6, 2017.
This blog concerns how to move data from non-partitioned warehouse tables to partitioned tables.
This issue comes up when warehousing has been done for some period of time without partitioning turned on in the warehouse proxy agent and summarization and pruning agent. Then the customer decides to use partitioning. If tables already exist in the WAREHOUS database without partitioning turned on then turning it on will not cause the data to start being partitioned. The data will continue to be inserted into the non-partitioned tables and there will likely be errors as it’s trying to insert partitioned data into non-partitioned tables.
Continue reading here.