AWR and restricted mode

From: amit poddar <amit.poddar_at_yale.edu>
Date: Wed, 15 Nov 2006 12:46:36 -0500
Message-ID: <455B527C.1010005@yale.edu>

Hi Folks,

SQL> exec dbms_workload_repository.create_snapshot; BEGIN dbms_workload_repository.create_snapshot; END;

*
ERROR at line 1:

ORA-13516: AWR Operation failed: database in restricted mode
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 10
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 33
ORA-06512: at line 1

Is it documented anywhere that AWR snapshot cannot be taken when the database is in restricted mode ?

thanks
amit

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Nov 15 2006 - 11:46:36 CST