Is it possible to have something like Union-FS for Oracle databases? I wonder if it is possible to have something like what Union-FS is for filesystems also for databases?
Usecase
You have a webapp (with Oracle as database in the backend) with several instances: One production app and several work areas in which developers can make their changes and push them to production.
The 'workarea-webapp' should &quot;see&quot; all data stored in the production DB but if one of the developers changes data or inserts/deletes data (stored in the db) this should not affect the production db.
For files we use Union-FS which works fine but I wonder how to provide something like this for Oracle databases (Standard Licence)?
You might be able to construct something like this using database links and views, but performance of those views in the development environment would likely be horrendous. That said, in general it is considered an extremely poor security practice to have production data be visible to non-production application instances, or to share any infrastructure (servers, network, storage) with them. In most computing environments it is specifically prohibited by best practice, if not by law, depending on the type of data being stored. 

In most of the places I have worked, according to the rules developers were not even allowed read-access to production data for any reason; no links between dev and production were allowed; and no copies of production data could be placed in dev environments. Any exceptions required senior management and security approval from multiple organizations and generally meant that dev environments wound up secured to the same level as production.