I am using SQL Developer to migrate a MySQL database into a 12c database. Everything seems to be working fine apart from the create of the IDENTITY columns on the tables. Instead of creating the primary key ID columns as IDENTITY columns it is creating BEFORE INSERT triggers on the tables - the columns in the MySQL database are auto incremented. According to the documentation I have found SQL Developer should detect that the database being migrated to is a 12c database & thus create the tables using the new IDENTITY feature in 12c. I found a setting in the Generation Options (Target Oracle Database 12c checkbox) which I have checked, but it is still creating the triggers instead of the identity columns.
Any ideas?