Home » SQL & PL/SQL » SQL & PL/SQL » running multiple packages in database (Oracle 10g)
running multiple packages in database [message #332747] Wed, 09 July 2008 10:11 Go to next message
kumarbo7
Messages: 19
Registered: March 2008
Location: New Jersey
Junior Member
hello,

I have almost 100 packages in my local system which I need to compile all packages in database.

Is there any command or package to run those 100 packages one-by-one,if error occurs throws exception in middle of the cycle and stops there itself.

Please let me know if you want more detailed explanation.

Thanks in advance.
Re: running multiple packages in database [message #332748 is a reply to message #332747] Wed, 09 July 2008 10:15 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

$ORACLE_HOME/rdbms/admin/utlrp.sql

[Updated on: Wed, 09 July 2008 10:15] by Moderator

Report message to a moderator

Re: running multiple packages in database [message #332750 is a reply to message #332747] Wed, 09 July 2008 10:19 Go to previous messageGo to next message
kumarbo7
Messages: 19
Registered: March 2008
Location: New Jersey
Junior Member
Thanks anacedent.

I will check my posting and follow the isntructions before creating topic.

Regards
-Kumar
Re: running multiple packages in database [message #332762 is a reply to message #332747] Wed, 09 July 2008 10:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DBMS_UTILITY.COMPILE_SCHEMA

Regards
Michel
Re: running multiple packages in database [message #332763 is a reply to message #332747] Wed, 09 July 2008 10:37 Go to previous messageGo to next message
kumarbo7
Messages: 19
Registered: March 2008
Location: New Jersey
Junior Member
Thanks Michel for your reply.

Regards,
Kumar
Re: running multiple packages in database [message #333195 is a reply to message #332747] Thu, 10 July 2008 15:57 Go to previous message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
Also oracle provides a script on all versions of the database at $ORACLE_HOME/rdbms/admin/utlrp.sql that will recompile in the correct order ALL invalid objects in the database.

This must be run as the user SYS, and there should be no other DDL on the database while running the script. Not following this recommendation may lead to deadlocks.

Previous Topic: load data from one table to another table avoiding duplicate data
Next Topic: SQL query
Goto Forum:
  


Current Time: Wed Dec 07 10:35:16 CST 2016

Total time taken to generate the page: 0.08634 seconds