TimesTen Error Messages

TT-02417

Cannot add not null column column_name unless it has a default value specified


Cause

If you use the ALTER TABLE statement to add a NOT NULL column, you must specify a default value.


Action

When you use the ALTER TABLE ADD statement to add a NOT NULL column, ensure that you specify a default value for the NOT NULL column.

For more information on ALTER TABLE, see ALTER TABLE in Oracle TimesTen In-Memory Database SQL Reference.


Additional Information

You cannot use the ALTER TABLE statement to add a NOT NULL column without specifying a default value.