How to exceute view without DBLink in oracle server I have 2 views, example V1 from Database  DB1 , V2 from database DB2, these 2 database server are remotely configured, I can able to execute these views separately without database link in the respective database server. Now i want to join these views and want to execute it without database link. How do I achieve it?
You must have a server (say X) with V1 (pointing at server Y) and V2 (pointing at server Z). Can't you use create GTTs (Global Temporary Tables) with V1 and V2 (this will happen on X) and then perform your join operation on the GTT tables on X using the data from GTT_V1 and GTT_V2? There's a good link here about using GTTs. Check out the guidelines section.