Recently we came upon a situation where it would be best to install a snapshot using a database link to another server at our facility. We have been able to get the database link to work correctly through SQL Plus but only after doing an alter session set global_names= true. Otherwise, we get the ORA-02085 error.
It seems that if I were to change my init.ora file to set the global_names = false, then I could resolve the error, but I don't know what kind of impact it would have on other scripts I have in place already.
All of the databases I connect to are local to the facility where I work, so using global names really isn't necessary, but I'd hate to change the global_names parameter and have things fail on me.
Any words of advice?
Click Here to Expand Forum to Full Width