(Sadly...) the first question one must ask when it comes to partitioning is... ... do I have a license for the partitioning option ? (And no, having Enterprise Edition does not mean that you do) :-( -- Connor McDonald =========================== email: connor_mcdonald@xxxxxxxxx web: http://www.oracledba.co.uk "Semper in excremento, sole profundum qui variat" -- //www.freelists.org/webpage/oracle-l