Problems consolidating databases
The next step in the migration process is to convert the captured model of the database to an Oracle-specific model.
The captured model contains data types, naming schemes etc.
The last step in the Migration Wizard is to move the data to the new database.
Migrating the data is a process that copies the data from the third-party database to the new tables in the Oracle database.
In general, Olsen said, the less complicated your systems are, the less time and money you'll end up spending to maintain, support and repair them.
"Let's keep this environment simple," he advised listeners.
If each database has its own virtual machine, users potentially could find themselves with hundreds -- or even thousands -- of VMs to monitor and maintain.
There are hundreds of databases in many Oracle environments, supporting different applications and running on a variety of server platforms.
Olsen said the ultimate goal of Oracle database consolidation is to keep costs down.
That includes both capital equipment costs and operational expenses, which he described as the "care and feeding" of database systems.
Once the conversion process has completed, SQL Developer has a model of what the converted database will look like.
This is used to generate SQL scripts for the creation of the new Oracle Database schema(s) and to run these scripts.