Error creating partitioned repository: ORA-14501: object is not partitioned (74635)

When creating a partitioned repository using the Performance Analysis for Oracle 7.0.x scripts, it fails when running the quest_pa_rep_create_new_partition.sql script to add new partitions:

SQL> @quest_pa_rep_create_new_partition.sql
Enter a tablespace name on which the new partition will be created: PART_DATA
old 27: storage_clause := ') STORAGE (INITIAL 20M NEXT 10M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) TABLESPACE &tablsp NOLOGGING';
new 27: storage_clause := ') STORAGE (INITIAL 20M NEXT 10M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) TABLESPACE PAREP NOLOGGING';
DECLARE
*
ERROR at line 1:
ORA-14501: object is not partitioned
ORA-06512: at line 16
ORA-06512: at line 44

Product defect

WORKAROUND

1. Drop the entire repository schema
2. Download the attached advanced_quest_sc_fact.sql and replace the one under ../agents/StealthCollect/7.0/data
3. Recreate the long term repository by following the Long_Term_Performance_repository_Partitioning.pdf

STATUS

Waiting for fix in a future release of Performance Analysis for Oracle.