Since you have RAID technology, I believe, no need to worry about where to keep your partitions, either in the same tablespace or in the different tablespaces. Best Regards, Syed Jaffar Hussain OCP, DBA Consultant "Freeman, Donald" <dofreeman@state. pa.us> To Sent by: "Oracle-L (E-mail)" oracle-l-bounce@f <oracle-l@xxxxxxxxxxxxx> reelists.org cc Subject 09/07/2004 04:44 Partitioning PM Please respond to dofreeman@xxxxxxx a.us The system is Oracle 9.2.0.5 on Windows 2000. We want to partition some = of our tables for performance. The data is loaded on 7 disks striped = and mirrored. My question is can I just create partitions in the = original tablespace and benefit from partitioning or do the partitions = have to be in separate tablespaces? Is the parallelism enabled at the = logical level through multiple partitions in different tablespaces or = just physically through striping? Don Freeman Database Administrator 1 Pennsylvania Dept of Health Bureau of Information Technology -- To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe To search the archives - //www.freelists.org/archives/oracle-l/ Visit us on www.alfransi.com.sa ====== Banque Saudi Fransi - Privacy Notice ====== This message is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any use of this information by persons or entities other than the intended recipient is prohibited. If you have received this in error, please contact the sender and delete the material from your computer. Any opinions and other information contained in this message that do not relate to the official business of Banque Saudi Fransi shall be understood as neither given or endorsed by it. Although precautions have been taken to ensure no viruses are present in this email, BSF cannot accept responsibility for any loss or damage arising from the use of this email or attachments. ====== Banque Saudi Fransi - Privacy Notice ====== -- To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe To search the archives - //www.freelists.org/archives/oracle-l/