Skip to Main Content
Forums

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!

SQL Developer 18.2 - generating INSERT statements using identity columns

Matthias HoysSep 20 2018 — edited Sep 25 2018

Hi,

I'm using SQL Developer 18.2 and Oracle SE 12.1.

I have some tables with identity columns (and corresponding system-generated sequences).

I now want to generate a DDL script including INSERT statements for the table data.

This works fine, but when I execute this DDL script on another database and after this try to add some new records to the tables with identity columns, there's a conflict because the START WITH value is not correctly set.

Is this a bug in SQL Developer or do I have to use Data Pump to transfer data this way?

Thanks,

Matthias
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 23 2018
Added on Sep 20 2018
#sql-developer
18 comments
2,980 views