2561756 - Cannot generate or reverse the VALIDATE NOVALIDATE state of column constraints - SAP PD | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2561756 - Cannot generate or reverse the VALIDATE NOVALIDATE state of column constraints - SAP PD

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.