Namit Jain 2012-02-09, 22:18
We found a bug recently, that partitioned views do not have storage descriptors.
We will fix this bug, but the existing data needs to be upgraded (if you really care about the describe output
of a view partition). It seems fairly difficult to come up with a sql script to change the existing data.
One other way to fix this problem would be to list all view partitions and then add them again after the
patch. For all partitions p of view v:
alter view v drop partition p;
alter view v add partition p;
How many people are using partitioned views ? Is the above solution OK for them ?