Multiple schema users in one Oracle database for Unifier deployments
I currently have about 8 Unifier environments for my development and test systems. When I initially set this up, I put each of these Unifier deployments on their own Oracle database. I am looking to simplify this by just creating one database and 8 unique schema users (one for each Unifier environment). This will allow me to cut back on the amount of databases I am running and will easily allow me to add new Unifier deployments by just adding a new schema user if needed.
Would this work? What are the downsides to this approach?