Porblem adding partition to index organized table

[GremlinHunter]

I am hoping someone here has an idea on this. We have a number of tables that are index organized tables. Every day as part of a job new partitions are created for several days from now.

Problem is that yesterday did not get any partitions created for it but partitions have been created for today and the next several days. As a result I can not just add in the missing partitions due to a ORA-14074 error.

I think I can just rename the partitions to fill the gaps then run a split clause to put the data in the correct partitions but I am not sure... Anyone delt with this before?

 

[Dagon]

You will probably need to do an "alter table ..split partition" instead.

 

[GremlinHunter]

So I gather. When I posted this I was under the impression that split did not create a new partition but redistributed data between existing ones. I know a little better now. At this point in time I am trying to work out how much data is too much to split. I am not keen on creating temp tables for 40+ tables to split an empty partition.