Sunday, April 24, 2011

Unable to generate ASH report due to error ORA-01722

Unable to generate ASH report due to error ORA-01722
======================================


When attempting to generate ASH report with "ashrpti.sql" or "ashrpt.sql",
it failed with ORA-01722.


Solution :
==========

Manually set DEFINE ON before executing ashrpt.sql

SQL> set define on
SQL> @$ORACLE_HOME/rdbms/admin/ashrpt.sql

No comments: