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
STATUS
Waiting for fix in a future release of Performance Analysis for Oracle.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy