> -----Original Message----- > I would like to get input from oracle-l community... There was a previous comment that the replacement of database objects can have ripple effects on dependent objects. I'll second that remark and add that if the database is constantly busy, you might never be able to acquire the needed locks to do your update without shutting down the application. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------