Q:

Oracle Partitioning

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. 

A:

Yes.  Oracle allows us to define partitions within partitions: it is called subpartitioning.

