Changing object schema prefix references in plsql code

From: Patrice sur GMail <>
Date: Thu, 9 Jun 2011 15:23:12 -0300
Message-ID: <>

I did it manually, but am wondering what larger sites do in this situation.

I imported some schemas from a very old db (8i) into a newer (11gR2) one but had to change the name of one schema.

The objects ended up in the new schema name all right, but plsql code in other schemas still included the old schema name as prefix for some objects.

If we could edit source$ it would be a cinch to change all references from the old schema name to the new one.

If I could have connected from 11gR2 to 8i using imp, I could have remapped objects though am not sure whether remap actually does change schema name references.

What do larger sites do when they have to change schema names in plsql? Do they edit each reference manually?

Is there an undocumented switch that would let one edit source$...

Maybe I overlooked a better, obvious way to do this. If yes, don't hesitate to let me know.



Received on Thu Jun 09 2011 - 13:23:12 CDT

Original text of this message