Oracle: ALTER TABLE ... MODIFY with increased precision for NUMBER

Hi folks,

a quick check: I have a column with type NUMBER(9) and I want to do an ALTER TABLE like this:

alter table t1 modify ( col3 NUMBER(12) );

Does this result in a physical reallocation of the table? What if the column is part of a primary key? I couldn't find doc on this yet. Thanks a lot!

Regards

    robert

Followup set to comp.databases Received on Mon Jan 31 2005 - 12:22:34 CST