Skip to Main Content

SQL & PL/SQL

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!

How to alter (add/modify/drop) column on a huge table(1 TB) when the Database is active and online?

2752941Aug 29 2018 — edited Sep 3 2018

We are trying to design the database to handle the Alter on a huge table(1 TB) without any downtime or locks while the Database is active and online. Could you give a way forward to achieve this.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 1 2018
Added on Aug 29 2018
19 comments
6,005 views