Aaron Digulla
Aaron Digulla

Reputation: 328614

Oracle 10g Partitioning: Can I partition a subtable?

I have a main table with a primary key and a partition column (a date) and five subtables which use foreign key references to the primary key.

Is there a way with Oracle 10g to partition the subtables in the same way as the main table without duplicating the partition column?

Upvotes: 1

Views: 472

Answers (1)

Todd Pierce
Todd Pierce

Reputation: 806

No, you need 11g for that function.

Upvotes: 3

Related Questions