This discussion is archived
2 Replies Latest reply: Nov 1, 2012 11:57 PM by Belt RSS

Global AWR on 10.2

Belt Newbie
Currently Being Moderated
Dear all,

I try to gather a global AWR on 10.2.0.1. I copy the awrgrpt.sql,awrgrpti.sql,awrginp.sql to 10.2.0.1 from 11.2.
When i exec awrgrpt.sql ,i get an error:

insts AWRRPT_INSTANCE_LIST_TYPE;
*
ERROR at line 15:
ORA-06550: line 15, column 11:
PLS-00201: identifier 'AWRRPT_INSTANCE_LIST_TYPE' must be declared
ORA-06550: line 15, column 11:
PL/SQL: Item ignored
ORA-06550: line 47, column 24:
PLS-00320: the declaration of the type of this expression is incomplete or
malformed
ORA-06550: line 48, column 4:
PL/SQL: ORA-00904: : invalid identifier
ORA-06550: line 46, column 4:
PL/SQL: SQL Statement ignored

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points