automating rollback script oracle
DBMS_METADATA_DIFF and a few metadata queries can automate this process. This example demonstrates 6 types of changes: 1) adding a column 2) incrementing a sequence 3) dropping a table 4) creating a table 5) changing a view 6) allocating an extent. create table user1.add_column(id number); create table user2.add_column(id number); alter table user2.add_column add some_column number(5); … Read more