If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

moving data into correct partition

Hi Gurus
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.