Mark, Zabair is making sure he explains himself clearer.. :) Kellyn Pot'Vin Senior Technical Consultant Enkitec DBAKevlar.com RMOUG Director of Training Days 2013 ~Tombez sept fois, se relever huit! ________________________________ From: Mark W. Farnham <mwf@xxxxxxxx> To: roon987@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx; oratune@xxxxxxxxx Sent: Thursday, November 29, 2012 12:34 PM Subject: RE: RE: Partitioning 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 -- //www.freelists.org/webpage/oracle-l