PL/SQL (MOSC)

MOSC Banner

2 package body;DBMS_WRR_INTERNAL & DBMS_WORKLOAD_REPLAY are invalid

edited Dec 3, 2012 11:48PM in PL/SQL (MOSC) 4 commentsAnswered
2 package body;DBMS_WRR_INTERNAL & DBMS_WORKLOAD_REPLAY are invalid& unable to compile.

Kindly let me know
1. how could I check any missing dependency in these 2 objects
2. I was not able to create package body
with:ORACLE_HOME/rdbms/admin/dbmswrr.sql & ORACLE_HOME}/rdbms/admin/prvtwrr.plb

all other objects & components in dba_registry are valid.

utlrp.sql has been run mutiple times.

SQL> select owner, object_name, object_type, status from dba_objects where status ='INVALID';

OWNER                          OBJECT_NAME                                        OBJECT_TYPE          STATUS
------------------------------ -------------------------------------------------- ------------------- ------------
SYS                            DBMS_WRR_INTERNAL                                  PACKAGE BODY        INVALID
SYS                            DBMS_WORKLOAD_REPLAY                               PACKAGE BODY        INVALID

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center