What happens if a partition field changes? Will that record move from one partition to the other? Thanks. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of david wendelken Sent: Wednesday, October 12, 2005 10:33 AM To: Oracle-L Subject: Re: Partitioning question Partitioning can also be used in transactional systems. And if you do, make sure it's on a field that has values that never change. -- //www.freelists.org/webpage/oracle-l For technical support please email tech_support@xxxxxxxxxxx or you can call (972)721-8257. This email has been scanned for all viruses by the MessageLabs Email Security System. This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use of this e-mail by persons or entities other than the addressee is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the material. ____________________________________________________________________ This email has been scanned for all viruses by the MessageLabs Email Security System. Any questions please call 972-721-8257 or email your request to tech_support@xxxxxxxxxxxx -- //www.freelists.org/webpage/oracle-l