There are 4 types of Oracle integrity constraints: disable novalidateenable novalidatedisable VALIDATEenable VALIDATE Disable novalidate does not validate both the original and the new data. For read-only tables for improved performance. This state is typically used when the data comes from a validated source, and the table is read-only. Therefore, the new data is not entered into the table. Use Novalidate in a data warehouse environment where data has been cleaned up. There is no need for validation at this time, so you can save a lot. Enable Novalidate not check the original data, new data check. disable validate the original data is verified, the new data is not verified. Typically, you use this state when you have to validate existing data without making modifications, and you do not need an index to improve performance. enable validate both the original data and the new data need to be verified. Default settings.
Oracle Constraint State