So, I have a foreign key and I enable it with novalidate because I wish to let transactions happen on that table ASAP, but not allow transactions that would enter garbage.
Could I then, after running a select that shows there are no rows violating the constraint, set that constraint as VALIDATED? I mean to set in sys.dba_constraints the VALIDATED column as VALIDATED instead of NOT VALIDATED without actually running alter table x_table enable validate constrait x_t_y_fk? Is there a way to set the VALIDATED column in sys.dba_tab_cosntraints without running that enable validate which will be blocking transactions?