Home » SQL & PL/SQL » SQL & PL/SQL » compiling procedures
compiling procedures [message #18638] Fri, 08 February 2002 02:25 Go to next message
krishna
Messages: 141
Registered: October 1998
Senior Member
How is it possible to compile all the procedures,packages and views present in a user's schema using a single select statement?

Report message to a moderator

Re: compiling procedures [message #18645 is a reply to message #18638] Fri, 08 February 2002 06:28 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
Connect internal and type:

exec dbms_utility.compile_schema('SCHEMA_NAME');

Report message to a moderator

Previous Topic: Re: Date format?
Next Topic: dbms_sql.parse
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 09:52:28 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.