adding a column on 15G table with not null and default 0 is very slow.
I have a table X and running following command to add column
ALTER TABLE X ADD ( col_new NUMBER(1,0) DEFAULT 0 NOT NULL) ; because of the size this is very very slow.
I tried couple of options one of the below but does not help.
Any help appreciated.
ALTER TABLE X ADD ( col_new NUMBER(1,0) DEFAULT 0 NOT NULL) ; because of the size this is very very slow.
I tried couple of options one of the below but does not help.
Any help appreciated.
0