1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to raplace table name in SP's

Discussion in 'SQL PL/SQL' started by bigbatra, Jul 15, 2009.

  1. bigbatra

    bigbatra Guest


    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.
  2. tyro

    tyro Forum Genius

    Likes Received:
    Trophy Points:
    See the source code of stored procedures is stored in data dictionary. But even if you were able to programmatically change the source code, who will compile them? I may be wrong but I don't think there's an easy way here. You may find that eventually to write a programme that would do this for you may take more time than manually editing the source code.