Changing object schema prefix references in plsql code
- From: Patrice sur GMail <patrice.boivin@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 9 Jun 2011 15:23:12 -0300
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.
^_^
Regards,
-- Patrice
My profiles: [image:
Facebook]<http://www.facebook.com/home.php?#!/profile.php?id=100000206805521>[image:
LinkedIn] <http://ca.linkedin.com/pub/patrice-boivin/a/933/5a9>[image:
Twitter] <http://www.twitter.com/PatriceBoivin>
<http://www.twitter.com/PatriceBoivin>
Signature powered by WiseStamp <http://www.wisestamp.com/email-install>
Other related posts:
