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;
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)