Home » SQL & PL/SQL » SQL & PL/SQL » How to compile all the Oracle Scripts at one-go?
How to compile all the Oracle Scripts at one-go? [message #412873] Mon, 13 July 2009 03:30 Go to next message
Hemanth123
Messages: 56
Registered: April 2009
Member
Hi,

Need your help in compiling all the oracle scripts at one time.
Is there a way where we can compile all Oracle Views,Alter Scripts,Stored Packages,Triggers at one-go..ie.by providing/passing username/password and servername once all the scripts should be compiled...

Any help is appreciable.

Thanks,
Hemanth
Re: How to compile all the Oracle Scripts at one-go? [message #412877 is a reply to message #412873] Mon, 13 July 2009 03:43 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
It's all in the fine documentation:

DBMS_UTILITY.COMPILE_SCHEMA
Re: How to compile all the Oracle Scripts at one-go? [message #412879 is a reply to message #412873] Mon, 13 July 2009 03:48 Go to previous message
psingh7777
Messages: 22
Registered: August 2007
Location: New Delhi
Junior Member

You can use.

DBMS_UTILITY.COMPILE_SCHEMA (
schema VARCHAR2,
compile_all BOOLEAN DEFAULT TRUE);

Be aware that you should have the privileges to run this script and alter privileges to DB objects of Schema.
Regards
Parvinder
Previous Topic: ORA-6513
Next Topic: When should I use correlated subqueries? (merged)
Goto Forum:
  


Current Time: Mon Feb 17 20:25:10 CST 2025