|
The definitions of some objects, including views and procedures, reference other objects, such as tables.
As a result, the objects being defined are dependent on the objects referenced in their definitions.
First check all the INVALID objects in the schema using :
select OBJECT_NAME,OBJECT_TYPE from user_objects where status='INVALID';
compile the objects accordingly....
ALTER PACKAGE my_package COMPILE;
ALTER PACKAGE my_package COMPILE BODY;
ALTER PROCEDURE my_procedure COMPILE;
ALTER FUNCTION my_function COMPILE;
ALTER TRIGGER my_trigger COMPILE;
ALTER VIEW my_view COMPILE;
|