I have 1 table which contain 8 subtables. Each subtable contains another 3 to 5 subtables. Now my question is that is it possible to partition tables by hierarchy? That means i like to keep all the tables info in one table and then create partitioning on them.
+2
A:
Yes. Oracle allows us to define partitions within partitions: it is called subpartitioning.
APC
2009-10-02 08:17:24