I have existing application that I am upsizing to oracle.

The problem i have it that The application needs to connect to multiple databases with the same structure.

The users login may have access to several oracle databases.

The upsize wizard creates the remote views without the oracle schema(database) name. Any manually created views have only the schema name they were created from.

What is the proper way to setup the connection to oracle such that one set of views can connect to all of the schemas dependant on what database the user wants to connect to ?