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.
Schema Migration for application upgrades
oracle
Related Question
- Should I use SQL or NoSQL for this specific design (surveys)
- Sql-server – Migrating Oracle packages to SqlServer
- Queries hang when accessing Oracle via ODBC and Python
- Find columns referenced by virtual column expression
- Problem with procedure performance
- PostgreSQL vs Oracle – Tool to Compare Databases
- Sql-server – How to do data migration between different schemas
- Give me suggestion about backup of schema and full backup in oracle
Best Answer
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.