I don't think I explained myself very clearly David. What I hoped for was say that we have created the new partitioned table (PART TEST2) with the subpartition template values of USABLE and UNUSABLE for status-name. Everything is working fine but now the requirement has changed and status-name will have an additional value of say NONUSABLE. How could this be handled. Sent from Yahoo! Mail on Android -- //www.freelists.org/webpage/oracle-l