Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> NOT NULL vs NULL column in a fact table
Hi all
I have several medium to large fact tables to which I need to add a NOT NULL column. In the past I would do the following:
This time however the number of the tables and the sizes are too big and I
don't think my normal process
will complete within a reasonable time. So I am now considering just adding
this column as nullable, and
modify it as not null when older partitions are dropped (in a year or two
or so) and I will ask the reporting team
to run the reports for this new column only for the months starting with
the one when this column was added.
What kind of problems am I asking for?
thank you
Gene Gurevich
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 04 2007 - 13:58:59 CDT