In Compare Schemas when only tables option is checked, column's not-null attribute is not in the (4327352)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

In Compare Schemas when only tables option is checked, column's not-null attribute is not in the
Description

In Compare Schemas when only tables option is checked, column's not-null attribute is not in the sync script
Example:
1. Create table test(id number not null,name varchar2(10));
2. Run Compare Schemas with either the constraints (CHECK) or tables option checked and sync script display
Create table test(id number,name varchar2(10));
Notice that not null is missing, if both options are checked, then the not null appears in sync script.
Resolution

This is happening because the NOT NULL attribute is really a check constraint. So you must compare constraints to compare these. Ensure that both Table and Constraint options are checked.
Defect ID

ST83799
Additional Information

Oracle generates a check constraint on the table for a not null column.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title