hi, I am using Oracle 9i. Facing a problem, Actually name of some tables has been changed in my database. Problem is that, I want to replace table name with new one in all stored procedures(count>100). This can be done manually,but it take lot of effort. Is there any script or tool using which i can automate this whole procedure. thanks in advance.