create partition taking too long
551675Oct 16 2008 — edited Oct 21 2008hi,
In our 11g database we have 15 tables which are range-list partitioned. Range partitioning on some of these tables is taking nearly 10mins/table and the whole process is taking nearly 1hour. actually we are splitting the existing partitions based on high bound value to create a new ones.
We use to do the same on our 10g database too..but there the whole process get finished in 10mins..
Is there any major changes in 11g db partitioning...??
and how can we speed up this partition creation....
I went through the Oracle 11g documentation..but didn't find anything to speed up the partition creation...
Please help us....