regarding AWK in oracle [message #425518] |
Fri, 09 October 2009 06:59 |
chandu_imax
Messages: 46 Registered: May 2008 Location: Hyderabad
|
Member |
|
|
Hi ALL,
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!
Regards,
Chandu
|
|
|