Hi,
I am having a table T1 which is having around 150 billion of data, i need to add not null constraint in few columns, is there a way to add which consumes less time
T1
id number
amt number(2,3)
dat_col date
dat_col_1 timestamp;
i used below query which is taking lot of time
alter table T1 modify(id not null,amt not null,dat_col not null,dat_col_1 not null);