moving data into correct partition
I'm running Oracle 9i on Linux 7.1. I got a 4 tables with 75,000 records. Long back these tables were created with pratitions 2800,2900 and maxvalue. Then after we got a project with data ranging 3200. This data went into maxvalue partition. Now i want to create some more partitions 3000,3100,3200 and move this data from maxvalue into appropriate new partitions. Is there any way to do this , with out dropping the tables and recreating them.
Many thanks in advance...
Click Here to Expand Forum to Full Width