Using Version 10.0.5.1710.
Would it be possible to have an option to validate while enabling a table check constraint in the object browser? I came across a situation at my work when a table column was created with a not null constraint, this constraint was disabled to allow some historical data with nulls in it to be loaded, the constraint then needed to be enabled for future data. The only way to do this is to enable with a 'no validate' which the PLSQL object browser doesn't give you.
Thanks
Paul
Would it be possible to have an option to validate while enabling a table check constraint in the object browser? I came across a situation at my work when a table column was created with a not null constraint, this constraint was disabled to allow some historical data with nulls in it to be loaded, the constraint then needed to be enabled for future data. The only way to do this is to enable with a 'no validate' which the PLSQL object browser doesn't give you.
Thanks
Paul