Skip to Main Content

SQL & PL/SQL

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!

Fastest way to add not null in existing column

944524Jan 18 2016 — edited Jan 18 2016

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);

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 15 2016
Added on Jan 18 2016
8 comments
8,313 views