Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Partitioning
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_at_freelists.org&subject=unsubscribe To search the archives - http://www.freelists.org/archives/oracle-l/Received on Tue Sep 07 2004 - 08:39:44 CDT
![]() |
![]() |