There are two different approaches to database consolidation namely: Organizations operate in a high competitive and regulated environment and so efficient and repeatable business processes are integral to an organization’s wellbeing.
This applies equally to the database consolidation process.
I am more experienced with SQL Server and Sybase than Oracle, and understand those products well.
The key phrase used in the above statement is “under certain criteria”.
Organizations should treat database consolidation as a continuous process.
At any given time, organizations will be either preparing for or executing a set of consolidation activities or phases.
Or would I have to merge the four databases into one database on the consolidated server and manage the schemas to ensure there are no name conflicts? I have read the documentation but I'm still not 100% sure about this area.
Running 4 instances on one machine is trivial, so I won't explain further.