I have an application which is running with an application schema on Oracle DB. The application needs to be upgraded to new version of Schema on Oracle DB with changes in Schema structure (Table Structure, Values, Entity Relations). Which tool/utility to use to reduce the downtime? Currently we are migrating the complete data using sql procedures and it is taking huge time (12 Hours). We want to reduce drastically the migration time at DB level.
Edition-Based Redefinition is perfect for this. You define schema changes in a new edition, along with procedures that are used to migrate the data between the base and new edition/schema. Switching between the two is seamless and can be done with zero downtime.
There's a good demo on the Oracle Base blog.