Zabair, are you sitting on your send button? Holy cow. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Zabair Ahmed Sent: Thursday, November 29, 2012 2:27 PM To: oracle-l@xxxxxxxxxxxxx; oratune@xxxxxxxxx Subject: Re: RE: Partitioning 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 -- //www.freelists.org/webpage/oracle-l