Is this an Oracle question, SQL Server question a mix of both?  Looking at the question and trying to understand it I am imagining some data resides on Oracle and other data in SQL Server.

We need some clarity here.....