Home » RDBMS Server » Server Administration » Packeage Compilation (solaris 9)
Packeage Compilation [message #337352] Wed, 30 July 2008 11:29 Go to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
I am compiling one package through toad.After some time it is getting invalid again.What can i do to compile it permanantly
Regards,
Varun Punj,
Re: Packeage Compilation [message #337354 is a reply to message #337352] Wed, 30 July 2008 11:37 Go to previous messageGo to next message
BlackSwan
Messages: 26766
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

>.What can i do to compile it permanantly
Stop changing objects it uses.
This is normal & expected behavior.
Do not worry about this.
Re: Packeage Compilation [message #337380 is a reply to message #337354] Wed, 30 July 2008 12:59 Go to previous message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Thanks a lot.
Regards,
Varun Punj,
Previous Topic: creation tablespace getting hanged
Next Topic: how to reduce the database size after dropping the schema
Goto Forum:
  


Current Time: Tue Dec 03 08:57:54 CST 2024