oracle-databaseoracle11gddloracle11gr2

Generate upgrade script to ALTER TABLE based on CREATE TABLE statement in Oracle

Is it possible in Oracle to generate a bunch of ALTER TABLE statements based on existing table in schema plus CREATE TABLE statement with newer definition of that table?

Let's say I have a schema with some previous version of an application. I have an installation script for newest version of the application. The script creates all tables and sequences from scratch performing CREATE TABLE (and probably CREATE SEQUENCE) statements.

I'd like to update the schema to the newest version of the application without loosing any data (e.g. without performing DROP TABLE).

Is it possible with using of standard Oracle 11gR2 or third party components?

Solution

  • You can try CORT : www.cort.tech
    https://github.com/cort-master/cort

    It's free