|
Tip of the Week
Tip for Week of October 17, 2005
Compile Dependent Objects
This tip comes from
Hector Ulloa, Oracle DBA/programmer, in Santiago, Chile.
This code compiles dependent objects. (This was built for use on Oracle9i Database.)
NOTE: ...
This code compiles dependent objects. (This was built for use on Oracle9i Database.)
DECLARE
v_referenciado varchar2(20):=' e.i. : Table1';
BEGIN
FOR c IN (
SELECT name,type,owner
FROM all_dependencies
WHERE referenced_name = v_referenciado
ORDER BY NAME
)
LOOP
dbms_ddl.alter_compile(c.type,c.owner,c.name);
END LOOP;
END ;
|
Bookmark
