I create a new database and import an older example database. When I attempt to refresh some of the existing materialized views they attempt to connect to the old sample databases MASTER_LINK instead of the new one I have defined. How do you alter the MASTER_LINK since it is in a view? I have tried altering the base tables SNAP$ and OBJ$ MASTER_LINK values and that changes the view value, BUT the refresh still gets the older link value!! Why? Where is it lurking?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.
Your password has been sent to:firstname.lastname@example.org
To follow this tag...
Thanks! We'll email you when relevant content is added and updated.
Share this item with your network: