Hi,
I have alot of views within a database. I know how to change the owner of the view itself but I need a script to change the inside i.e. when I go to design/modify, it is referencing to the wrong owner like proddta.table1 I want to change all the views to be changed to crpdta.table1
Can someone send me a script that can do that? I would really appreciate it. Thank you. Andre