According to the document on Long-TermPerformance Repository Partitioning Option, the scripts for implementing partitioned repository can be found in the Performance Analysis Agent Installation\Installation Scripts directory on the DVD.
Do not have Installation DVD.
The installation scriptscan also befound in the <agent installation directory>\StealthCollect\6.0\data directory once the Performance Agent Installation has been run on the middle-tier machine hosting the middleware.
1. Install Middleware component on the middle-tier machine.
2. Navigate to <agent installation directory>\StealthCollect\6.0\data directory.
3. Copy the entire content from this above directory to a directory in the Repository Database server.
Partitioning option must be enabled on the repository database server.
Partition repository is available from Performance Analysis Oracle version6.5 onwards.
The partition repository schema version remains at 6.0.