300,000 rows is a very small number for partitioning. That said, if you're going to partition the parent table, you should consider using partition by reference for the child table if you're using 11g. http://download.oracle.com/docs/cd/B28359_01/server.111/b32024/part_admin.htm#BAJDDEEC -- Adam Musch ahmusch@xxxxxxxxx -- //www.freelists.org/webpage/oracle-l