Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Risks when adding a column to a table

1945078Mar 10 2015 — edited Mar 11 2015

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 8 2015
Added on Mar 10 2015
8 comments
18,884 views