Symptom
- It is not possible to generate a SQL script to create a constraint on an Oracle column using the VALIDATE / NOVALIDATE keyword defining the constraint state.
- It is also not reversed.
- Examples of appropriate syntax:
ALTER TABLE table MODIFY column NOT NULL NOVALIDATE;
ALTER TABLE table
ADD CHECK (column IS NOT NULL) NOVALIDATE;
ALTER TABLE table
ADD CONSTRAINT constraint CHECK (column IS NOT NULL) NOVALIDATE;
Read more...
Environment
- SAP PowerDesigner (PD) 16.6
- Oracle DBMS
Product
SAP PowerDesigner 16.6
Keywords
RE, "reverse engineering", enable, disable, 811790, CR811790, CR#811790 , KBA , BC-SYB-PD , PowerDesigner , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview