Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Please some opinion in the free partitioning for Oracle standard Edition project
Hi, if you have some feedback please this is the proyect basically, I hope
be in this year
check it first please.
http://www.oracleboliviaspecialists.com/partition_scheme.bmp
For every thing there is a function in a master package for every partitioned table, for example there is a function to create addition partitions
The main benefits are the fact
1. to create historic data, you can create a new partition and move it to a
read only tablespace
2. you can improve the access in historic tables having a lot of historic
rows which are rarely accessed
This doesn't too simple, but the performance improvement in big tables
deserves the effort.
I either see really as a complex proyect to program, is true there will be
lots of details, specially to add list partitioning, etc.
If you have some idea about improving this free project partitioning
concept, you are welcome.
:)
-- ---------------------------------------- http://www.oracleboliviaspecialists.com/ Oracle Certified Profesional 9i 10g Orace Certified Professional Developer 6i 10 years of experience from Oracle 7 to Oracle10g and developer 6i -- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 14 2006 - 12:46:59 CDT
![]() |
![]() |