-
I am currently running a db version 8.1.6 on solaris and NT..
I have a table that need to be partitioned. It already has data in them. I don't want to export the data, create a new structure with partition and then import the data. I want to be able to do that dynamically.. What are the issues I might need to become aware of interms of performance, possibility and how do I do that?? Thanks..
-
If your partitioned table is going to be the same structure as your original table, then it is really easy.
First, create your partitioned table with one partition that is partitioned on maxvalue. Then, exchange your existing table into the partitioned table. Once your table is a partitioned table, you can split the partitions into as many partitions as you want.
