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!

modifying column datatype in large tables

user594312Nov 9 2011 — edited Nov 10 2011

Hi

I have a very big table 3TB and 97 partitions and I need to extend the size of one column. This operation can take a long time and I worry that it will block some SQL operations. What is the recommended way to do this? Should I use modify column? Should I add the column, copy the values, delete the old one, and rename it?

Regards,

Néstor Boscán

This post has been answered by AdamMartin on Nov 10 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 8 2011

Added on Nov 9 2011

8 comments

867 views