Can we be able to rollback specific schema changes that includes ddl and dml as part of release.
Can we be able to rollback specific schema changes that include DDL and DML as part of the release? I want to find out below scenario is possible.
Release implementation and rollback possibility:
A ) Apply release scripts that may include DDL and DML operations.
B ) Once testing is done, It is decided to roll back all the changes applied in this schema only.
Is this possible in oracle please let me know.
Thanks.
NOTE: Database restore point is not an option, as there are multiple schemas with transactions happening and we cannot lose the data also.