create package body
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
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
0