Friday, April 08, 2005

Compiling invalid objects

The following command can be used to compile all invalid objects in a schema.
exec dbms_utility.compile_schema( 'SCHEMA NAME');

to re compile a proceedure individually you can use the folloeing:
alter procedure proc_name compile;

No comments: