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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment