title: how to "re-validate" a foreign constraint in oracle
body: <p>I have a foreign constraint as below. This was created like three years ago. All the data that are created after this constraint are valid but the backlog data (data before three years) are not valid. Toad shows this constraint as 'Not Validated'</p>
  
  <pre><code>ALTER TABLE ISSUES ADD (
    CONSTRAINT FK_CLIENT 
   FOREIGN KEY (CLIENT) 
   REFERENCES REPORTERS(USERID)
      DEFERRABLE INITIALLY DEFERRED);
  </code></pre>
  
  <p>Today i fixed all the backlog data and now this constraint will hold good both for existing as well as new data. But how will i make the constraint as 'Validated'. </p>
  
  <p>Is there any way to 're-validate' a foreign constraint?</p>