2 Replies Latest reply on Nov 2, 2012 6:57 AM by Belt

    Global AWR on 10.2

      Dear all,

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

      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
      ORA-06550: line 48, column 4:
      PL/SQL: ORA-00904: : invalid identifier
      ORA-06550: line 46, column 4:
      PL/SQL: SQL Statement ignored