Help with refactoring

[Marcus Rangel]

Hello everybody,

My company has a system that is composed of modules, each one in an Oracle schema (AF,BA,BE,CG,etc). We are changing it to a single schema (KIPREV), so we need to find any references to the owners (like "SELECT CODIGO FROM PA.USUARIOS") inside the packages and procedures, changing them to either KIPREV ("SELECT CODIGO FROM KIPREV.USUARIOS") or to nothing ("SELECT CODIGO FROM USUARIOS"). Can PLSQLDev refactoring help us do that ?

 

[Marco Kalter]

No, the refactoring function will not help. You will have to do some finding & replacing. There are some command-line replace tools that can help with this if there are a lot of files and/or a lot of searches.