The limitations of the Esri + Oracle (per 12c) were the cause. 12c Oracle will allow for Multi-Tenant DB, allowing us to have multiple SDE GeoDB as we need. This will meeting the need for one owner, and multiple creators in a schema.
Background: Oracle 11g, ArcServer 10.3.1
Our group is trying to organize our geodatabase based on application, much like how SQL Server creates its instances.
All our tables are at the master SDE level, which means that there are impacts on other application during schema deployments or esri upgrades.
We looked at User Geodatabase (user schemas), but they only allow for only editor/creator at the Geodatabase level.
Outside of creating one Oracle instance per application, what are others doing in order to allow for multiple owners and editors?