|regarding AWK in oracle [message #425518]
||Fri, 09 October 2009 06:59
Registered: May 2008
I am getting with the following error when I am running the AWK report.
Specify the Report Name
The default report file name is awrrpt_1_19198_19199.html. To use this name,
press <return> to continue, otherwise enter an alternative.
Enter value for report_name:
Using the report name awrrpt_1_19198_19199.html
select output from table(dbms_workload_repository.awr_report_html( :dbid,
ERROR at line 1:
ORA-04063: package body "SYS.DBMS_SWRF_REPORT_INTERNAL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SWRF_REPORT_INTERNAL"
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 309
ORA-06512: at line 1
Please help me in this regard. Thanks in Advance!