Hi We are using version 11.2.0.4 of oracle. We have a requirement in which we have to make ~12 columns from NULL to NOT NULL in one existing transaction table which is daily range partitioned. Its having ~500Gb in size having ~29million rows and ~31 columns in it. We had faced issue during altering a big table in past as that took very long time. So wanted expert suggestion, what will be the best way to achieve this?