Of Interest
Business Intelligence and Analytics
Oracle Training
|
Oracle
»
Administration
»
Fix
»
Invalid
Fixing Invalid Objects
How to fix invalid objects - procedures, packages, triggers.
Using this proc to detect and rebuild should solve many issues.
CREATE OR REPLACE PROCEDURE P_holtdw_fix_invalid
IS
CURSOR program_units IS
SELECT object_name, object_type
FROM user_objects
WHERE object_type IN
('PROCEDURE','FUNCTION','PACKAGE', 'PACKAGE BODY', 'TRIGGER')
AND object_name <> 'TEST' and status = 'INVALID' ;
BEGIN
FOR x IN program_units LOOP
P_print ( x.object_name ) ;
DBMS_DDL.ALTER_COMPILE (x.object_type,'HOLTDW',x.object_name);
END LOOP;
END;
/
|
|
|
Get the latest Rocket99 news and tech tips via
|
