Oracle Question

[joero4]

Here is my situation...

A Table exist with fields that accept NULL values.
Views and Indexs have also been created from that same table.

I now want to update the original table so that the fields do not accept NULL values (NOT NULL). Is it neccessary to re-create the views and indexs if I update the fields in the table?

Thanks,
Joe

 

[jimbopalmer]

Putting the constrant on the table is enough. (Oracle may implement the constraint via indexes, but that will be automatic) I tried to remain child-like, all I acheived was childish.

 

[sem]

If this field contains null values, you should also provide default value or create DISABLEd constarint .