Hi,
I have a large table which we need to add a new column to. I want to check if there is much risk in adding a column to a table, and also removing the column if a rollback is required.
It is quite large table, so it will be very time consuming to backing up by create a backup table or by datapump. Restoring the previous nights backup to a non-default location will also be even longer process.
I'm only changing the tables structure and not deleting any data. So I want o check if there's any risk in losing the table is something went wrong.
Thanks