11g purge scripts growth

History of purge scripts and its portability

1st version of purge scripts came only in PS1 or 11.1.1.2.0 release this had purge based on instance state, composite name, and version


2nd version of purge scripts came only in PS2 or 11.1.1.3.0 release. for the 1st time Full partition concept was introduced


3rd version of purge scripts was available in PS3 or 11.1.1.4.0 release it was know as " purging for Extremely large environments support"
Purge script was changed and made it very simple. partition purge concept was also supported

this script was not compatible to work on older patch sets(PS1 amd ps2) as there was change in the way the scripts works.
So there is backport_scripts which would work fine on PS2 and PS1 was developed


4th version no enhancement were made available in PS4 or 11.1.1.5.0 release.


5th version more enhancement were made available in PS5 or 11.1.1.6.0 release. this includes

Partial Partitioning of Component tables
Purge By Composite DN
Partitioning Strategy for long running processes introducing "Row Movement strategy "
NOTE: there is no backport scripts available for this so far