Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

4.0EA1 Exporting table DDL puts Not Null constraint as alter statement

AMJul 31 2013 — edited Aug 6 2013

This was an issue with in release 3.2.10.09 as well

Exporting tables with not null constraints exports DDL with not null constraint as Alter table statement. In browser right click on table -> Quick DDL -> Save to Worksheet. Issue is same when table is exported by other options.

This has undesirable effect when table is reference partitioned then the create table command as constructed by export can not be played as Not Null constraint is not inline.

This is not an issue when viewing table SQL in table information window.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 3 2013
Added on Jul 31 2013
1 comment
418 views