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!

Alter table - modify column size -- zero down time upgrade?

592169Mar 3 2010 — edited Mar 3 2010

Hello all,

I have a table with billion records, and have a column

COL_A varchar2(200)

I have an upgrade script which does the following ...

Alter table X modify (COL_A varcha2(2000)); -- increases column size to 2000

I am curious to know whether such a table alteration would result in a zero-down-time upgrade, or whether there would be a row_scan on each row within my table to increase the size for the column, which would result in a non-zdu upgrade scenario?

Please share your thoughts on what would happen.

Thanks

AJ

Edited by: A.J. on Mar 3, 2010 11:38 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 31 2010

Added on Mar 3 2010

#general-database-discussions, #table

2 comments

1,961 views