Quick question: alter table ... modify column NOT NULL...
665143Aug 24 2009 — edited Aug 24 2009Hey all,
If I modify 3 populated (they have data) columns in a table with approximately 300 million rows from NULL to NOT NULL:
alter table blah
modify (col1 NOT NULL, col2 NOT NULL, col3 NOT NULL);
... will this roughly "take a while?"
I know it's a REALLY high-level question, but I'm wondering how much time it should consume (a few minutes or many minutes - looking for a rough answer as well). The table has 10 columns, if that helps.
Hardware specs are irrelevant... I'm just looking for a basic answer.