need to change partition scheme
I have a table with 150 million rows in 10g with 50 patitions. I want to increse the no of partitions recommended by Oracle to increase performance. This table is very busy table and I can't get down time more than 2 hrs.
case1. If i create a new table with new partition scheme and export -import data in the down time it takes more than 6 hrs, and I cann't get 6hrs down time.
Case2. If i export and import the data in new table without down time there will be lot of datachange in the mean time and I dont have any way to get the difference b/w data.
case1. If i create a new table with new partition scheme and export -import data in the down time it takes more than 6 hrs, and I cann't get 6hrs down time.
Case2. If i export and import the data in new table without down time there will be lot of datachange in the mean time and I dont have any way to get the difference b/w data.
0