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

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

    tyro Forum Genius

    Messages:
    368
    Likes Received:
    20
    Trophy Points:
    260
    Location:
    India
    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.