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 1Is it documented anywhere that AWR snapshot cannot be taken when the database is in restricted mode ?
thanks amit -- //www.freelists.org/webpage/oracle-l