Let's imagine a standard situation.
Having the current DB schema in a working state, I would like to create a snapshot of this state of schema objects, name it SNAP_1
.
Then if updated schema and got problems (bugs or unstable work of new code) it would be good to switch quickly - in one command - the whole schema code back to SNAP_1
.
I'm wondering is there any built-in feature of Oracle DBMS for versioning:
- PL/SQL code (schema objects)
- Data (for example, within configuration tables)
Does Oracle DBMS give native tools for versioning at least one of these two?